Line Chart in QlikView is very useful to connect individual dots. We can use the QlikView line chart to find the Forecast details, or trend in sales etc. In this article we will show you, How to Create a Line 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 Line Chart in QlikView
In this example we will create a Line chart for all the product colors that are present in our data source. This might help us to analyze which colored product is trending than the other. To do this, we are going to use the Color Column as the dimension data (X-Axis), and the Sales Amount expression on the Y-Axis.
We can create a QlikView Line chart in multiple ways: 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 Line Chart. As you can see from the below screenshot, we assigned a new name called Line Chart to our chart, and then selected the Line Chart as the chart type
Please select the Dimension column that you want to use in your Line chart. For this example, we are adding the Color dimension to the used dimension section. It means, it will add the Color dimension to X-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 for your Y-Axis 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.
Here you can specify the sorting order for the Color dimensions. In this example, you can sort the Color in Ascending, or Descending order.
Next page is used to change the look, and style of a Line chart. Here we are changing the Plot Color Style to Light Gradient.
Here you can change the Presentation of a Line chart. For example, you can change the Bar settings, you can enable scrolling on axis etc.
Colors page is useful to change the Color pattern of the Line chart. I think you should try different options
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 Semibold, and Font size to 11
Use this Layout page to provide the shadow effects to your Line 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 Medium, and Border width to 3 (extra thickness to border).
Caption page is used to style the QlikView Line Chart Caption. Here you can change the background, position, color, and so on for your Line Chart. As you can see from the below screenshot, we changed the Active, and Inactive Caption Text colors. Once you done, click the Finish button
Now you can see our newly created Line Chart in QlikView.
Create Multiple Line Charts in QlikView
Through above chart fulfilled our requirement. Let me check the sales trend for each country. In order to do so, we have to add country dimension to existing Line chart. For this, 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 Dimension tab -> add Country to Used Dimensions -> Next, use the promote button to move country dimension to top position.
Now you see the sales trend for each color, and country
Let me hover over my mouse on the line chart. As you can see from the below screenshot, it is displaying the Country Name, Color, and it’s Sales amount (Data label).
Thank You for Visiting Our Blog