Bar Chart in QlikView is very useful in comparing the data visually. Let us see the steps involved in creating the Bar Chart in QlikView with an example. For this Bar Chart demo, we are going to use the data present in the following Excel table.
For example, If we want to check the Sales by Country, Region, or Continent, we can use this QlikView bar chart. By seeing this bar chart, One can understand, Which country, or region is performing better compared to others.
From the screenshot below, see that we are loading the above specified excel sheet into the QlikView.
Create a Bar Chart in QlikView
In this Bar Chart example, we find out which color product is performing better than the other. For this, we use the Color Column on the X-Axis and the Sales Amount expression on the Y-Axis.
We can create a bar chart in multiple ways: Please navigate to Layout Menu, select the New Sheet Object, and then select the Charts.. option
The second approach is to right-click on the Report area opens the Context menu. Please select the New Sheet Object, and then select the Charts.. option.
Either way opens a new window to create a Bar Chart in QlikView
Step 1 – General: From the below screenshot, see we assigned a new name to it and then selected the Bar Chart as the type
Step 2 – Dimensions: Please select the Dimension column to use in X-Axis.
- Available Filed/Groups: List of all the available columns or groups displayed under this section.
- Used Dimensions: All the columns that are present in this section are used in the Bar Chart.
- Add: This button adds the Available columns to the used columns section.
- Remove: This button removes the columns from the used columns section.
- Add Calculated Dimension: It opens the Edit Expression window to write a custom expression.
For now, we are adding the Color dimension to the used dimension section. Refer Import data from Excel article in QlikView to import the excel tables.
Step 3 – Expression: Clicking the Next button at Dimension page opens the Expression page, and on top of that, a pop-up window opened. Use this QlikView bar Chart window to write the custom expression for the Y-Axis data, or select the Columns.
Here, we are selecting the Filed as Sales Amount, and Aggregation as Sum. Remember, if you know how to write an expression, then write it on the empty space under the Expression OK section.
Clicking the OK button, edit expression window closed.
- Label: By default, the text under the Definition section displayed as the Y-Axis label. It means, Sum(SalesAmount). To change that default text, place the custom text under this section.
- Values on Data Points: It shows the Data Points or Data labels for each bar present in it. It mean Sales Amount displayed on top of each colored bar.
Step 4 – Sort: Under this section, we can specify the sorting order for the dimensions on the x-axis.
Step 5 – Style: This QlikView Bar Chart page is to change the style or look. Here we can select the 3D, Horizontal, Vertical, or 2D bar chart.
From the below screenshot, see that we had selected the standard bar chart
Step 6 – Presentation: Here, we can change the Bar Chart’s 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 it. Here, we are selecting the Multicolored option. By this, it displays different colors for the different colored products.
Step 9 – Number: Use this QlikView Bar Chart page to format the Expression value. It only reflects when we 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, it is money so that we can select the money.
Step 10 – Font: Please change the font’s font family, style, and size as per requirements. All these changes 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. Use this page to alter it.
Step 12 – Caption: Use this page to stylized the bar Chart Caption. For example, its color, background, position, etc. Once complete, click the Finish button.
Now, see our newly created Bar Chart in QlikView.
