Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

siddharth_s2
New 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?

Tags (1)
3 Replies

Re: Create table with number of day names in a month

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

siddharth_s2
New Contributor III

Re: Create table with number of day names in a month

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

Re: Create table with number of day names in a month

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

- Marcus

Community Browser