Is there a easy way to create Line Chart with Secondary Dimension Values ?

[jambesh]

I searched how to create a line chart with multiple lines based on a secondary dimension but unfortunately, I found several complex solutions (like creating expression using dual) to create a simple multiline chart. Spent several hours to figure out but no luck.

Here is the data looks like:

Order Date on X-Axis

Sales on Y axis for line

Ship Mode: will be on color to show multiple line for each shipping methods.

I thought Qlik was easy, but I felt, it is like Assembly Language for me after using Tableau.

Attached is the screenshot that i am looking to create in Qlik.

[Sayed_Mannan]

Creating a line chart with multiple lines based on a secondary dimension in QlikSense is straightforward. Here are the steps:

In edit mode, turn on the advanced options.

Drag a line chart from the assets panel onto the sheet.

Add ‘Order Date’ as a dimension.
Add ‘Ship Mode’ as a second dimension from the properties panel. Each distinct ‘Ship Mode’ in the data model becomes a separate line in the chart.
Add ‘Sales’ as a measure.

This will create a line chart with ‘Order Date’ on the X-axis, ‘Sales’ on the Y-axis, and a line for each ‘Ship Mode’. The color of each line will represent a different shipping method.

Remember, you can adjust its appearance and other settings in the properties panel. For information about styling, see Styling the line chart.

I hope this helps! Let me know if you have any other questions.

[jambesh]

@Sayed_Mannan  Not in Qliksense , I am trying to do in Qlik View desktop 

[Sayed_Mannan]

You can do this in the QlikView:-

1. Open QlikView and load your data.
2. Go to the menu bar, click on Layout -> New Sheet Object -> Chart.
3. In the Chart Type tab, select Line Chart.
4. In the Dimensions tab, add Order Date as the first dimension and 'Ship Mode as the second dimension.
5. In the Expressions tab, add Sales as a measure.
6. Click Finish to create the chart.

This will create a line chart with Order Date on the X-axis, Sales on the Y-axis, and a line for each Ship Mode.