Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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! 😄
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