topic 3Month and 12Month Rolling based on availability in QlikView

3Month and 12Month Rolling based on availability

Akhil — Mon, 09 Dec 2019 10:15:25 GMT

I have a count of available stocks and not available stocks for every month.

Available stock: A

Not available stock : B

So I want to show 3M and 12M rolling based on the availability ....like ex : if stock are available for more than 3months but less than 12 than i would like to show 3M rolling average else 12M rolling average.

Can it be done ?

Re: 3Month and 12Month Rolling based on availability

Taoufiq_Zarra — Mon, 09 Dec 2019 13:24:28 GMT

Hi,

can you share an extract from your source data to help you in the best way possible

Cheers,

Re: 3Month and 12Month Rolling based on availability

Brett_Bleess — Tue, 17 Dec 2019 16:38:37 GMT

You can also check the Design Blog area if you cannot attach sample data etc.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

That is the base URL, but the following may be what you need for this specific use case:

https://community.qlik.com/t5/Qlik-Design-Blog/Accumulations/ba-p/1466581

https://community.qlik.com/t5/Qlik-Design-Blog/Average-Which-average/ba-p/1466654

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

I think the first one in the list is the best fit, but I included the others too just in case.

Regards,
Brett