AsOf table

[raakesh498]

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?

[sunny_talwar]

Do you have a sample we can look at and help you with?

[raakesh498]

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

[sunny_talwar]

Would you be able to share the script you used to create the AsOfTable?

[Brett_Bleess]

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