Bar Chart in QlikView

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.

Excel File 1

From the screenshot below, see that we are loading the above specified excel sheet into the QlikView.

Load Excel Sheet 2

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

Goto Layout Menu and Choose New Sheet Object and Chart submenu 3

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.

Right-Click on Empty Space to Choose New Sheet Object and Chart submenu 4

Either way opens a new window to create a Bar Chart in QlikView

Bar Chart in QlikView 5

Step 1 – General: From the below screenshot, see we assigned a new name to it and then selected the Bar Chart as the type

Assign Window Title name 6

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.

Add Available Fields to User Dimension 7

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.

Edit Expression window 8

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.

Write SUM expresión and click ok 9

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.
Click Next button  10

Step 4 – Sort: Under this section, we can specify the sorting order for the dimensions on the x-axis.

Bar Chart in QlikView 11

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.

Bar Chart in QlikView 12

From the below screenshot, see that we had selected the standard bar chart

Bar Chart in QlikView 13

Step 6 – Presentation: Here, we can change the Bar Chart’s Bar settings.

Bar Chart in QlikView 14

Axes: Use this Axes page to change the axes setting.

Bar Chart in QlikView 15

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.

Bar Chart in QlikView 16

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.

Bar Chart in QlikView 17

Step 10 – Font: Please change the font’s font family, style, and size as per requirements. All these changes reflected in the Chart report

Bar Chart in QlikView 18

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.

Bar Chart in QlikView 19

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.

Bar Chart in QlikView 20

Now, see our newly created Bar Chart in QlikView.

Bar Chart in QlikView 21