topic Re: AsOf table in QlikView

AsOf table

raakesh498 — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: AsOf table

sunny_talwar — Thu, 16 Jul 2020 12:53:18 GMT

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

Re: AsOf table

raakesh498 — Thu, 16 Jul 2020 13:36:08 GMT

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

Re: AsOf table

sunny_talwar — Thu, 16 Jul 2020 17:56:58 GMT

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

Re: AsOf table

Brett_Bleess — Tue, 28 Jul 2020 21:29:03 GMT

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