Block Chart in QlikView is useful to visualize the text data. For example, If are looking for Most commonly used Tags in your website, or trending Twitter hashtags then you can use this Block chart. In this article we will show you, How to Create a Block 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 Block Chart in QlikView
In this example we will create a Block chart for all the states that are present in our data source. To do this, we are going to use the State Column as the dimension data, and the Sales Amount expression as the Block size.
We can create a QlikView Block chart in multiple ways: Please navigate to Layout Menu, select the New Sheet Object, and then select the Charts.. option
Another approach: 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 Block Chart. As you can see from the below screenshot, we assigned a new name called Block Chart Example to our chart, and then selected the Block Chart as the chart type
Please select the Dimension column that you want to use in your Block chart. For this example, we are adding the State dimension to the used dimension section. It means, it will create a separate block for each state.
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 for your Block Chart data, or you can select the Columns.
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.
Click OK button to close the edit expression window, and then click Next button.
Next page is used to change the look, and style of a Block chart. Here we are changing the Plot Color Style to Light Gradient.
Presentation page is used to alter the Block chart presentation settings
Colors page is useful to change the Color pattern of the Block chart. I think you should play with them
Next, we are 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 page to change the Font family, style, and font size as per your requirements. From the below screenshot you can see that, we changed the Font = Segoe WP Black, and Font size to 11
Use this Layout page to provide the shadow effects to your Block 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 soft, and Border width to 2 (extra thickness to border).
Caption page is used to style the QlikView Block Chart Caption. Here you can change the background, position, color, and so on for the Block Chart. As you can see from the below screenshot, we changed the Caption Text color. Once you done, click the Finish button
Now you can see our newly created Block Chart in QlikView.
Let me hover over my mouse on New South Wales state. As you can see from the below screenshot, it is displaying the State Name, and it’s Sales amount (Data label).
Thank You for Visiting Our Blog