Grid Chart in QlikView is similar to Scatter Plot but it uses the Dimension values on X-Axis, Y-Axis, and use an expression to visualize the data. In this article we will show you, How to Create a Grid 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 observe 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 Grid Chart in QlikView
In this example we will create a Grid chart and for this, we are going to use the Country, Color, Profession Columns as the dimension data, and the Sales Amount as an expression.
We can create a QlikView Grid chart in multiple ways. First Approach: Please navigate to Layout Menu, select the New Sheet Object, and then select the Charts.. option
Another 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 Grid Chart. As you can see from the below screenshot, we assigned a new name called Example for Grid Chart to our chart, and then selected the Grid Chart as the chart type
Please select the Dimensions (columns) that you want to use in your Grid chart. For this example, we are adding the Country, Color, Occupation dimensions to the used dimension section. It means, it will add the Country to X-Axis, and Color dimension to Y-Axis.
Once you click on the Next button, it will open an Expression page and on top of that, a pop up window called Edit Expression will be opened. You can use this window to write the custom expression.
As you can see from the below screenshot, we are writing an expression under the Expression OK section. If you don’t know how to write an expression then select the Filed as Sales Amount, Aggregation as Sum, and click the Paste button. Here size of the Bubble, or symbol will depends upon this expression value.
Click OK button to close the edit expression window, and then click Next button.
You can specify the sorting order for the dimensions in this Sort page. In this example, you can sort the Country in Ascending, or Descending order.
Next page is used to change the look, and style of a grid chart. Let me change the Plot Color Style to Light Gradient, and Plot Area background Style to Minimal.
Presentation page is used to change the Presentation of a Grid chart. For example, you can change the Symbol size, you can enable scrolling on axis etc. For now, we changed the Symbol size to 3pt
Use this Axis page to change the X-Axis, and Y-Axis settings.
Colors page is useful to change the Color pattern of the Grid chart. Try different options
Formatting the Expression value: As we all know that the Sum of Sales Amount is money, we are selecting the money.
You can use this Font page to change the Font family, style, and font size as per your requirements. Here, we changed the Font = Leelawadee, and Font size to 11
Use this Layout page to provide the shadow effects to your Grid chart, or you can apply the custom theme by clicking the Apply Theme button. As you can see from the below screenshot, we changed the shadow intensity to Intense, and Border width to 3.
Caption page is used to style the QlikView Grid Chart Caption. Here you can change the background, position, color, and so on for your Grid Chart. As you can see from the below screenshot, we changed the Active Text colors, and it’s background color. Once you done, click the Finish button
Now you can see our newly created Grid Chart in QlikView.
Through above chart fulfilled our requirement, we are unable to identify the Occupation with least sales. Let me change the Chart style. In order to do so, right-click on the Chart will open the context menu. Please select the properties option from that context menu.
Once you click on the properties option, a new window called Chart Properties will be opened as we shown below. Please navigate to Style tab, and change the Look.
Now you see that the Grid chart is displaying the Pie Charts instead of bubble chart.
Let me hover over my mouse on the Pie chart. As you can see from the below screenshot, it is displaying the Country Name, Color, Occupation, and it’s Sales amount (Data label).
Thank You for Visiting Our Blog