Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Create table with number of day names in a month

Hi All,

I need assistance in creating a table like below and have no idea on how to go about it.

    

MonthTotal SundaysSundays LeftTotal MondaysMondays LeftTotal TuesdaysTuesdays Left
Jan404040
Feb404040
Mar404040
Apr404040
May404040
June404040
July404040
Aug404040
Sep414141
Oct444444
Nov444444
Dec444444

So basically, it is a table which says how many number of days each month has and how many are left.

Can this be achieved?

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

You could get such table just by using Month and Weekday as dimensions from a master-calendar: How to use - Master-Calendar and Date-Values within a pivot-chart and then using as expressions something like this:

count(Date) // totals

count({< Date = {">=$(=today())"}>} Date) // left regarding to today

- Marcus

Highlighted
Contributor III
Contributor III

Thanks,

So what I did was to generate a master calendar in the load script. I have the first and last day of the month. But could you give a script as to how to calculate a specific day between 2 dates.

Say I want to calculate the number of Sundays between 01/01/2017 and 01//31/2017, how do I do it?

Help is appreciated. Thanks

Highlighted
MVP & Luminary
MVP & Luminary

It was meant to use Month as vertically dimension and Weekday as horizontally dimension and than using just the above mentioned count-functions.

- Marcus