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

Announcements
Qlik Unveils New Agentic Capabilities Across Analytics, Data Engineering, and Trust: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
coco_manel
Contributor II
Contributor II

YTD for multipl years

Hello, i want in a bar char to show the profit over year month dimension. also i made a button to select YTD calculation, but the problem is that when i select two years for example instead of showing YTD for each year it cumulates and shows the wrong value. Do you know what should i add into the set expression in such way that once that i select two years after ending the first one in the bar chart then the second starts over again and it calculates the YTD? Thank you! 😄

Labels (3)
1 Reply
hic
Former Employee
Former Employee

If you have YearMonth as first dimension, you could have Year as second dimension. Then it should restart automatically.

For additional ideas on how to visualize data over several years, take a look at:
https://community.qlik.com/t5/Design/Year-over-Year-Comparisons/ba-p/1462927
https://community.qlik.com/t5/Design/Cyclic-or-Sequential/ba-p/1467402
https://community.qlik.com/t5/Design/Relative-Calendar-Fields/ba-p/1473620