Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
vicga2611
Contributor II
Contributor II

Measure to buy sales between previous year VS current year

Good afternoon colleagues,

I have the following question, it turns out that I have an indicator type chart, and I want to compare the sales between the current year and the previous year. putting as a reference the sum of the previous year vs what is carried for the current year

Greetings.

Labels (1)
3 Replies
Anil_Babu_Samineni

You can create dynamic reference lines to achieve this.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
vicga2611
Contributor II
Contributor II
Author

what I don't understand is how to create that measure

 

best regards.

Anil_Babu_Samineni

You can see reference expression in property there you can use your expression as per logic.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful