Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
kakani87
Specialist
Specialist

Show 3rd Saturday in every month

Hi Everyone,

I would like to Display 3rd saturday in all months

Can anyone help me out of this.

Regards,

Kishore.

PFA.

stalwar1

tamilarasu

tresesco

1 Solution

Accepted Solutions
sunny_talwar

May be this

If(WeekDay(tran_date) = 'Sat' and Day(tran_date) > 15 and Day(tran_date) < 21, 1) as Third_Saturday

Capture.PNG

View solution in original post

2 Replies
sunny_talwar

May be this

If(WeekDay(tran_date) = 'Sat' and Day(tran_date) > 15 and Day(tran_date) < 21, 1) as Third_Saturday

Capture.PNG

kakani87
Specialist
Specialist
Author

Happy to say this worked Sunny