Line Chart in QlikView

Line Chart in QlikView is handy to connect individual dots. We can use the line chart to find the Forecast details or trends in sales, etc. Let us see how to Create a Line Chart in QlikView with an example. For this line chart demo, we are going to use the data present in the following Excel table.

Excel File 1

From the screenshot below, see that we are loading the above specified excel sheet into the QlikView and use it for Line chart.

Load Excel File 2

Create a Line Chart in QlikView

In this example, we create a QlikView Line chart for all the product colors that are present in our data source. It might help us to analyze which colored product is trending more than the other. To do this, we 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.

Choose New Sheet Object and Chart from Layout Menu 3

Another approach is to Right-click on the Report area open the Context menu. Please select the New Sheet Object, and then select the Charts.. option.

Line Chart in QlikView 4

Either way, QlikView opens a new window to create a Line Chart. From the below screenshot, see that we assigned a new name, and then selected the Line Chart as the type

Line Chart in QlikView 5

Please select the Dimension column to use in the QlikView Line chart. For this example, we are adding the Color dimension to the used dimension section.

It means it adds the Color dimension to X-Axis. Please refer to the Import data from Excel to QlikView article in QlikView to import the Excel tables.

Add Dimension Fields 6

Clicking the Next button opens an Expression page, and on top of that, a pop-up window called Edit Expression opened. Use this window to write the custom expression for Y-Axis data, or select the Columns.

Here, we are writing an expression under the Expression OK section. If you don’t know how to write an expression, select the Filed as Sales Amount, Aggregation as Sum, and click the Paste button.

Edit Expression 7

Click the OK button to close the edit expression window and click the Next button.

Check Expression and click next 8

Here, we can specify the sorting order for the Color dimensions. In this QlikView line chart example, we sort the Color in Ascending order.

Choose Sort Dimension (color) 9

The next page is to change the look and style of a QlikView Line chart. Here, we are changing the Plot Color Style to Light Gradient.

Choose the Plot Color Style 10

Here, change the Presentation of a QlikView Line chart. For example, we can change the Bar settings, enable the scrolling axis, etc.

Format the Presentation settings 11

The colors page is useful to change the Color pattern of the Line chart. Try different options!.

Change the Color 12

Next, we are formatting the Expression value. As we all know that the Sum of the Sales Amount is money, so we are selecting the money.

Line Chart in QlikView 13

Use this page to change the Font family, style, and font size as per requirements. From the below screenshot, see that we changed the Font = Segoe WP Semibold, and Font size to 11

Line Chart in QlikView 14

Use this Layout page to provide the shadow effects to the QlikView Line chart, or apply the custom theme by clicking the Apply Theme button. From the screenshot below, see that we changed the shadow intensity to Medium, and the Border width to 3 (extra thickness to the border).

Line Chart in QlikView 15

The caption page is to style the QlikView Line Chart Caption. Here, we can change the background, position, color, and so on for the Line Chart. Here, we changed the Active and Inactive Caption Text colors. Once complete, click the Finish button

Line Chart in QlikView 16

Now, see our newly created Line Chart.

Line Chart in QlikView 17

Create Multiple Line Charts in QlikView

Through the above one fulfilled our requirement. Let us check the sales trend for each country. To do so, we have to add the country dimension to the existing Line chart. For this, right-click on it and select the properties option from the context menu.

Line Chart in QlikView 18

Clicking the properties option opens a new window called Properties. Please navigate to the Dimension tab -> add Country to Used Dimensions -> Next, use the promote button to move the country dimension to the top position.

Line Chart in QlikView 19

Now, see the sales trend for each color and country.

Line Chart in QlikView 20

Let us hover over the mouse on the QlikView line chart. See that it is displaying the Country Name, Color, and Sales amount (Data label).

Line Chart in QlikView 21