Solved: Multiple conditions for a date range on one flag ... - Qlik Community

Domino1 · ‎2022-04-15

Hello,

Fiscal Year start is : Oct 1 and ends : Sept 30

Requirement is need to flag all dates that is within Sept 30 - Oct 1 regardless of year.

If there is a 9/30 and 10/1 between StartDate and EndDate - need to flag it.

Tried many variations of if statements such as below and no luck.

If ( StartYear < EndYear and StartMonth <10 and EndMonth >10 , 0, 1)

See attached file .

vikasmahajan · ‎2022-04-15

Hi

You need to implement master calendar see below script:

https://community.qlik.com/t5/QlikView-Documents/Fiscal-and-Standard-Calendar-generation/ta-p/148082...

Regards

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

View solution in original post

vikasmahajan · ‎2022-04-15

Hi

You need to implement master calendar see below script:

https://community.qlik.com/t5/QlikView-Documents/Fiscal-and-Standard-Calendar-generation/ta-p/148082...

Regards

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Multiple conditions for a date range on one flag ?

expression

Set Analysis