Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My rolling12months is defined in terms of months.
My chart has 'Month' as dimension.
Now i need to show the rolling12months data against each month which should ignore dimension(=month) but not selections.
Could anyone help on this please?
Do you have a sample we can look at and help you with?
Hi Sunny,
Thanks for the response!
In the above screenshot, below chart is showing sum of days for rolling 12 months against month using rangesum(above(sum,0,12)).
Where as the above one is which i am trying to achieve the same result using AsOf table. Where Rolling Months are linked to Months i.e., Rollingmonths = Jan/20, Feb/20,Mar20,....etc.
It is working fine when i give single month in the expression for above chart i.e., =Sum({$<Rolling12Months={'Jan/20'}>}
Total #LeaveDays)
Please let me know if you need more info.
Thanks,
Rakesh
Would you be able to share the script you used to create the AsOfTable?
In addition to Sunny's post, here is a Design Blog post that may be of some help too:
https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130
If you want to search further in that area, use the following link:
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
Regards,
Brett