Discussion board where members can get started with Qlik Sense.
Hi Guys i just wanted to find no of Odd Saturdays between two given dates.
There is a Even function that you could possible use on the day portion of the date.
If it is Odd then the value returned by this expression is 0.
I personally have never used this. But it seems straightforward enough.
There are also functions to determine the day of the week to pick out just Saturdays.
Hopefully that will send you down the right path.
Thanks for your response Mark
But there are possibilities that an odd Saturday(1st,3rd,5th saturday) can come on even day(even Date of month) so that logic won't work.
Any other approach would be appreciated