Comparative analysis of Workdays This Month vs. Last Month

[amanjain57]

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?

[sunny_talwar]

May be using The As-Of Table

[amanjain57]

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]

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.