Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
SwathiHS
Contributor
Contributor

Line chart

I need to build a line chart for four years data.

Measure is the orders count. I need to separate the years (2016, 2017,2018,2019) from the orderdate and plot four lines ranging from January to December.

Labels (1)
3 Replies
mdurso2626
Contributor II
Contributor II

I'd suggest creating flags in your load script for each year, then using set analysis to create a measure of each order count by year. You can then add the yearly measures to your line chart as individual lines.

Prashant_Naik
Partner
Partner

Hi,

Or you can create a Master Calendar 

And putting your Measure as Order Count and Dimension as Year.

Regards,

Prashant

kashyap
Partner
Partner

Hi

take

1st Dimension: Month

2nd Dimension: Year

measure

This will give the separate line for each year

Hope this helps

Thanks