Line Chart in QlikView

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

Line Chart in QlikView 1

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

Line Chart in QlikView 2

Create a Line Chart in QlikView

In this QlikView example, we create a 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 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

Line Chart in QlikView 3

Another 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.

Line Chart in QlikView 4

Either way, it opens a new window to create a Line Chart. From the below screenshot, see that we assigned a new name called Line Chart, and then selected the Line Chart as the chart 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 Import data from Excel to QlikView article in QlikView to import the excel tables.

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

Line Chart in QlikView 7

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

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

Line Chart in QlikView 9

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

Line Chart in QlikView 10

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

Line Chart in QlikView 11

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

Line Chart in QlikView 12

Next, we are formatting the Expression value. As we all know that the Sum of Sales Amount is money, 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 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 chart 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 the Chart and select the properties option from the context menu.

Line Chart in QlikView 18

Clicking the properties option opens a new window called Chart Properties. Please navigate to Dimension tab -> add Country to Used Dimensions -> Next, use the promote button to move country dimension to 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