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

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

Calculate Number of working days between Sundays

Hi All i have a requirement that i need to calculate the working days between two any given sundays. Attached is the QVW file which will have  _FlagWorkingDay column if  _FlagWorkingDay=0 then its not a working day and if  _FlagWorkingDay=1 then it is a working day. Now i want the output like this in my final table should look like i need dates related to sundays and working days related to that sunday. Please let me know in case of any questions. i am attaching the QVW file.

10 Replies
Anonymous
Not applicable
Author

Hey Massimo, Thanks a lot for your help. You are my guru . Need to learn some of the scripting from you man..I tried in a different manner. attached is my qvw file.