Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
srujanaponnuru
Creator
Creator

rolling QTD for selected period

Hi All,

i have a requirement as below:

I have QTD dates as :

20200301

20200601

20200901

20201201

 

in my Monthyear filter i am selecting Dec-2020 and i have written rolling QTD calculation as below in set analysis:

Datenum = {">=$(=num(date(monthstart(quarterend(max(MonthYear)),-6)))) < = $(=num(date(monthstart(quarterend(max(MonthYear))))))"} 

my output is coming as:

DEc-2020`
Nov-2020
Oct-2020
Sep-2020
Aug-2020
Jul-2020

Jun-2020 

But i don't want all the months: 

i need my output to come when i select monthyear filter Dec 2020

Dec 2020
Sep -2020
Jun-2020

  i need only above months to come in my output. please suggest. 

 

 

Labels (1)
1 Reply
MayilVahanan

HI @srujanaponnuru 

Try like below

Datenum = {'$(=num(date(monthstart(max(MonthYear),-6))))','$(=num(date(monthstart(max(MonthYear),-3))))',

'$(=num(date(monthstart(max(MonthYear)))))'} 

Hope it helps.

Check the brackets once

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.