topic Comparative analysis of Workdays This Month vs. Last Month in App Development

Comparative analysis of Workdays This Month vs. Last Month

amanjain57 — Thu, 30 Mar 2017 18:52:39 GMT

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 — Thu, 30 Mar 2017 18:53:14 GMT

amanjain57 — Thu, 30 Mar 2017 18:58:40 GMT

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 — Thu, 30 Mar 2017 19:05:11 GMT

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 — Thu, 30 Mar 2017 19:21:59 GMT

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.