Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130