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 QlikView 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 QlikView bar chart, One can understand, Which country, or region is performing better compared to others.

Bar Chart in QlikView 1

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

Bar Chart in QlikView 2

Create a Bar Chart in QlikView

In this QlikView 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 QlikView bar chart in multiple ways: Please navigate to Layout Menu, select the New Sheet Object, and then select the Charts.. option

Bar Chart in QlikView 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.

Bar Chart in QlikView 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 our chart, and then selected the Bar Chart as the chart type

Bar Chart in QlikView 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 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 to QlikView article in QlikView to import the excel tables.

Bar Chart in QlikView 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.

Bar Chart in QlikView 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.

Bar Chart in QlikView 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 our bar chart. It mean Sales Amount displayed on top of each colored bar.
Bar Chart in QlikView 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 of the bar chart. Here we can select the 3D bar chart, Horizontal, Vertical bar Chart, 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 QlikView 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 the bar chart. 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 family, style, and size of the font 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 QlikView 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