Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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