Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Rolling 13 months for get field selections

 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 

Labels (1)
2 Replies
Specialist II
Specialist II

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.

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.