Restrict the filter values with current month ,previous month and previous 4 quarters.

[meenakshi_m]

Hi ,

Appreciate if anyone could help on this -

Dimension is COB date which has daily as well as monthly dates . This is a Filter in the Qlik dashboard and  want to restrict the dates for selection.

COB dates  restricted in filter should be

current month date     

previous month max date

previous 4 quarter max dates.

COB date (DD/MM/YYYY)

18/03/2020

31/03/2020

12/04/2020

15/06/2020

30/06/2020

14/09/2020

31/09/2020

17/12/2020

31/12/2020

1/1/2021

[Anil_Babu_Samineni]

Perhaps this?

If(Date=Max(TOTAL [COB date]), Date([COB date]),
If(Date=AddMonths(Max(TOTAL [COB date]),-1), Date([COB date]),
Date(QuarterEnd([COB date]))))