Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calendar with Week of the Month

Good Day,

     I have a problem showing the Week of each Month, If there a  multiple Selection of month i need to show the week of them on a bar chart,

not the summary of each month, Becuase its a Drill Down.

Regards,

raem.paks

1 Reply
Jason_Michaelides
Partner - Master II
Partner - Master II

So you want to return a number that is always between 1 and 5 inclusive?

Have you tried (in the script):

Floor(Day(Date)/7)+1     AS     Week

Hope this helps,

Jason