Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
amanjain57
Creator II
Creator II

Comparative analysis of Workdays This Month vs. Last Month

Error 7.JPG

I want to Duplicate this chart in QlikSense.

What it does is that from the data

Example:

Month December - Identify the working days(Exclude Saturday and Sunday) and give the measure : Sum(Sales)

Month November - Identify the working days(Exclude Saturday and Sunday) and give the measure : Sum(Sales)

It should be able to do side by side comparison of workday vs. workday.

What should i do to accomplish this?

4 Replies
sunny_talwar

May be using The As-Of Table

amanjain57
Creator II
Creator II
Author

Hi Sunny,

I just need Qlik to identify workdays from the date.

How is that possible??

Still not sure how the above function could help.

sunny_talwar

You can use WeekDay() function to determine the day and then based on that you can use an if or pick(match()) if a date is workday or not

amanjain57
Creator II
Creator II
Author

What should be done to give the WORKDAY NUMBER to the days in a month???

Since I want to have comparative analysis of these workdays.