Month start and month end

[#1]

Hi all,

jagan‌

I have campaigns which starts on monday and ends on sunday.now i need the counts based on these campaigns and also month wise.

for example:  for month wise counts : in October last week the campaign starts on 26/10/2015 and ends on 01/11/2015.

Now for the October month count i need to exclude this campaigns data and include it to november month count.

My actual concept is if campaign starts in the last month and ends in present month, then My month start or counts should be taken from that campaign start date of the last month, and the month end or counts till the last sunday of the current month.

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

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

Help on this how can i achieve this, through load script or set analysis.

Thanks,

Kumar

[brunobertels]

Hi

See my app attached with the calendar Script and some table and KPI

Have a look if it helps you

I can't do more as I am a newbie in QlikSense as well.

link this script with an ID to your data (Here DateID)

Can you explain which set expression can i use

1. to get the number of days in monthperiod.

add this in the script as dimension

  autonumber(Date,date(weekend(Date),'MM-YY')) as Nbr_Of_Day

try this expression as mesure :

aggr(count(CanonicalDate),MonthPeriod1)

2. if date is dec-11-2015 the number of days completed till that date in monthperiod or number of days passed from today in monthperiod.

the number of days will be the total of days for december and not the number passed from today

3. # of tuesdays in a monthperiod

aggr(count(Tuesday),MonthPeriod1)

4. # of tuesday passed from today() :

I don't know