Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor 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
Highlighted

Re: Comparative analysis of Workdays This Month vs. Last Month

May be using The As-Of Table

Highlighted
Contributor II

Re: Comparative analysis of Workdays This Month vs. Last Month

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.

Highlighted

Re: Comparative analysis of Workdays This Month vs. Last Month

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

Highlighted
Contributor II

Re: Comparative analysis of Workdays This Month vs. Last Month

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.