Discussion board where members can learn more about Qlik Sense App Development and Usage.
I want to Duplicate this chart in QlikSense.
What it does is that from the data
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?
May be using The As-Of Table
I just need Qlik to identify workdays from the date.
How is that possible??
Still not sure how the above function could help.
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
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.