Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

No. of Days

Hi all,

I have a Load Script like below:

    Month(weekend(CanonicalDate)) as MonthPeriod,

    Date(MonthStart(weekend(CanonicalDate)),'MMM-YY') as MonthPeriod1,

These script gives me a monthperiod like:

Example: 1)  October month count: from sep 28th  to   Oct 25th.

               2)  November month count : from oct 26th  to Nov 29th.

How can i get the # of days for the month according to the above format?



Tags (1)
1 Reply
Esteemed Contributor

Re: No. of Days

try what I have already suggested you on your another thread:

Custom MonthStart and MonthEnd

I was having same scenario and sorted it in this way

Community Browser