topic Re: Rolling 13 months for get field selections in App Development

Rolling 13 months for get field selections

saradhi_it — Sat, 16 Nov 2024 17:28:46 GMT

Hi Team

I had requirement in my app i have two filter panes which is year and month these are used in the charts and tables through get field selections ,Now user is asking for 2 charts one is 13 months and another 24 month charts

if user is selecting any year and month (current selection) in my chart 13 months rolling sales need to come and another chart 24 months rolling sales ,If user selected Feb19 data should be populated from Jan 18 to jan 19 data in the charts

Re: Rolling 13 months for get field selections

micheledenardi — Thu, 18 Feb 2021 07:59:20 GMT

The best solution is to create 2 flags on your master calendar, one which refers to 13 months rolling and the other one to 24 months rolling. Then use these flags in your charts expression.

Hope this is enough, otherwise provide some example data we can use to build the solution.

Re: Rolling 13 months for get field selections

MayilVahanan — Thu, 18 Feb 2021 08:38:11 GMT

Hi @saradhi_it

You can refer the same kind of scenario here.

https://community.qlik.com/t5/QlikView-App-Dev/Rolling-12-months-sum/td-p/1039841

Other reference too:

https://community.qlik.com/t5/QlikView-Documents/Calculating-rolling-n-period-totals-averages-or-other/ta-p/1483033

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