3Month and 12Month Rolling based on availability

[Akhil]

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 ?

[Taoufiq_Zarra]

Hi,

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

Cheers,

[Brett_Bleess]

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