You will need to create an additional Calendar to achieve this easily.
Create a calendar say First Day of the Month is Last Monday of the previous Month and Last day on the month is last Sunday of the month.
The calendar will look like below.
Month 1 - Jan - (29Dec2014 - 25Jan2015)
Month 2 - Feb - (26Jan2015 - 28Feb2015) and So on
Once the calendar is created and associated to your data model you will get your results as expected
Hope this helps.
I think this will not works, because we are not taking all last monday of previous month as startday of the present month,
because we will take only in the situation where campaign/week starts in last month and ends in present month.
In the above scenario only we will take last monday of previous month as start day of present month.
i found your answer in below discussion.
can you please provide the .qvf file as i don't have qlikview.
And i need counts of tuesday for above scenario.
Means number of tuesday in November month as i take month as explained above and also if i am in middle of the month number of tuesday passed from start of the month.
Can you please help with it.