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

meenakshi_m — Fri, 01 Jan 2021 10:13:52 GMT

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

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

Anil_Babu_Samineni — Fri, 01 Jan 2021 16:18:22 GMT

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]))))

topic Re: Restrict the filter values with current month ,previous month and previous 4 quarters. in App Development

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

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