topic Re: While between two dates - whichever is less in QlikView

While between two dates - whichever is less

qlikwiz123 — Thu, 19 Aug 2021 15:14:02 GMT

I am generating months and years between two dates as below.

LOAD
Date(AddMonths(MonthStart($(vDateMin)),IterNo()-1),'MMM YYYY') as Months,
Year(Date(AddMonths(MonthStart($(vDateMin)),IterNo()-1),'MMM YYYY')) as Years

//Date(AddYears(YearStart($(vDateMin)),IterNo()-1),'YYYY') as Years

RESIDENT JIRA

While AddMonths(MonthStart($(vDateMin)),IterNo()-1) <= MonthStart(End Date);

I need to add another date (03/31/2022) in WHILE where it generates the years until End Date or 03/31/2022 - whichever date is less. How do I do that?

Re: While between two dates - whichever is less

Kushal_Chawda — Thu, 19 Aug 2021 16:13:25 GMT

@qlikwiz123 may be this

While AddMonths(MonthStart($(vDateMin)),IterNo()-1) <= rangemin(MonthStart(End Date), makedate(2022,3,21));

Re: While between two dates - whichever is less

qlikwiz123 — Thu, 19 Aug 2021 17:48:38 GMT

This worked perfectly. Thank you @Kushal_Chawda