How to define rain season in master calendar?

[sogloqlik]

Hi,

I Gather rain data in my area and i want to upload it to qlik.

Now,  rain season is defined from Sep. to May the following  year. for example rain season 2018-2019 would mean Sep. 2018 to May 2019. how can i build it so I would be able to compare rain seasons?

Thx,

Motty.

[passionate]

Create a flag in master calendar.
Using
num(MONTH(Date(tmpdate,'M/D/YY'))) as [Monthnum]
And then check if Monthnum is greater than 9 or less than 6 then rainy season.
To get flag between sep and may

[dplr-rn · Accepted solution]

Try something like this

if(Month(CalDate)>=9,'Rain Season '& Year(CalDate) &'-' & (Year(CalDate)+1)
    	, if(Month(CalDate)<=5,'Rain Season '& (Year(CalDate)-1) &'-' & Year(CalDate))
        ) as RainYear