Defining Time Period Filter

[amala2020]

Hi Team,

I am very new to Qlik.

I need to create a time filter as mentioned below considering today as max date( 16-12-2021).

 From 23-April 2021 to Till Last month( 11-2021)  As 'Start Date to Last_Month'

From 23-April 2021 to Till Last Quarter( 9-2021)  As 'Start Date to Last_Quarter'

From 23-April 2021 to Till Last Week( 19-12-2021)  As 'Start Date to Last_Week'

I have tried like below, but it is not working.

  if( [Master PUBLISHED DATE]>= Date(Date#(20211216,'YYYYMMDD'),'DD-MM-YYYY')

     and [Master PUBLISHED DATE]<=date#(AddMonths(vMaxDate,-1)),'Prog. Start-Monthly',

         if( [Master PUBLISHED DATE]>= Date(Date#(20211216,'YYYYMMDD'),'DD-MM-YYYY')

             and [Master PUBLISHED DATE]<=DATE(AddMonths(vMaxDate,-3)),'Prog. Start-Quarterly',

                           if( [Master PUBLISHED DATE]>= Date(Date#(20211216,'YYYYMMDD'),'DD-MM-YYYY')

                             and [Master PUBLISHED DATE]<=Date#(vMaxDate - 7),'Prog. Start-Weekly'

         )       )       ) as Time_Period

Can any one help me as this is little urgent

[Chanty4u]

Hi 

what is the error you are getting?

first thing  master publish date is in which format? 

and vmaxdate - what is the result it is showing? 

and try  with one if condition first and check  if it is working then add second .

like that you can debug the issue