Discussion board where members can get started with Qlik Sense.
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?
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