Bar Chart in QlikView is very useful to compare the data visually. For example, If you want to check the Sales by Country, Region, or Continent we can use this bar chart. By seeing this bar chart, One can understand, Which country, or region is performing better compared to other.
In this article we will show you the steps involved in creating the Bar Chart in QlikView with example. For this we are going to use the data present in the following Excel table.
From the below screenshot you can see that, we are loading the above specified excel sheet into the QlikView. I suggest you to refer Import data from Excel to QlikView article to understand the steps involved in importing the excel tables.
Create a Bar Chart in QlikView
In this example we will find out, which color product is performing better than the other. For this, we are going to use the Color Column on the X-Axis, and the Sales Amount expression on the Y-Axis.
We can create a QlikView bar chart in multiple ways: Please navigate to Layout Menu, select the New Sheet Object, and then select the Charts.. option
Second approach is to right-click on the Report area will open the Context menu. From the context menu, Please select the New Sheet Object, and then select the Charts.. option.
Either ways, it will open a new window to create a Bar Chart as we shown below:
Step 1 – General: As you can see from the below screenshot, we assigned a new name to our chart, and then selected the Bar Chart as the chart type
Step 2 – Dimensions: Please select the Dimension column that you want to use in your X-Axis.
- Available Filed/Groups: List of all the available columns, or groups will be displayed under this section.
- Used Dimensions: All the columns that are present in this section will be used for the Bar Chart.
- Add: This button is used to add the Available columns to used columns section.
- Remove: This button will remove the columns from used columns section.
- Add Calculated Dimension: It will open the Edit Expression window to write your custom expression
For now, we are adding the Color dimension to the used dimension section.
Step 3 – Expression: Once you click the Next button at Dimension page, it will open the Expression page and on top of that, a pop up window will be opened. You can use this window to write the custom expression for the Y-Axis data, or you can select the Columns
From the below screenshot you can see that, we are selecting the Filed as Sales Amount, and Aggregation as Sum. Remember, if you know how to write an expression then you can simply write it on the empty space under the Expression OK section
Once you click OK button, edit expression window will be closed.
- Label: By default text under the Definition section will be displayed as the Y-Axis label. It means, Sum(SalesAmount). In order to change that default text, you can place the custom text under this section.
- Values on Data Points: It will show the Data Points, or Data label for each bar present in our bar chart. I mean, Sales Amount will be displayed on top of each colored bar.
Step 4 – Sort: Under this section, you can specify the sorting order for the dimensions on the x-axis.
Step 5 – Style: This page is used to change the style, or look of the bar chart. Here you can select the 3D bar chart, Horizontal, Vertical bar Chart, or 2D bar chart.
From the below screenshot you can see that, we had selected the normal bar chart
Step 6 – Presentation: Here you can change the Bar settings.
Axes: Use this Axes page to change the axes setting.
Step 8 – Colors: This page is very helpful to change the Color pattern of the bar chart. From the below screenshot you can see that, we are selecting the Multicolored option. By this it will display different colors for different colored product.
Step 9 – Number: You can use this page to format the Expression value. This will be reflected only when you display the data labels, or data points. For example, here we are displaying the Sum of Sales Amount on the y-axis. As we all know that, it is money so you can select the money.
Step 10 – Font: Please change the Font family, style, and size of the font as per your requirements. All these changes will be reflected in the Chart report
Step 11 – Layout: As we selected the Shadow bar chart, it is showing the setting to alter the shadow intensity etc. You can use this page to alter it.
Step 12 – Caption: Use this page to stylized the QlikView bar Chart Caption. For example, its color, background, position etc. Once you done, clik the Finish button.
Now you can see our newly created Bar Chart in QlikView.
Thank You for Visiting Our Blog