Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.

3 Replies
Anonymous
Not applicable

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 - Creator II
Partner - Creator II

Hi,

Or you can create a Master Calendar 

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

Regards,

Prashant

Kashyap_R
Partner - Specialist
Partner - Specialist

Hi

take

1st Dimension: Month

2nd Dimension: Year

measure

This will give the separate line for each year

Hope this helps

Thanks

Thanks and Regards
Kashyap.R