Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created a master calender which is linked with actual data with Transaction Date field.
If I select year and month in Calendar and no other selections, It shows following date period.
Jan 1 2012 to Jan 31 2013 - This is correct.
But when I do any more selections apart from Year and month like Currency, it shows date period as
Jan 5 2012 to Jan 31 2013
This is because it filter on the basis of data availability.
But I want to show only period as Jan 1 2012 to Jan 31 2013, irrespective of other selections.
I am using Qlikview version 11.20.
How can this be accomplished.
Thanks
You could use monthstart(min([Transaction Date])) instead of just min([Transaction Date]) in the expression that displays the reporting range.
Thanks.
But I have Fortnight1,Fortnight2,Week1,Week2,Week3,Week4,Week5,
Q1,Q2,Q3,Q4,Half Yearly1 and Half Yearly2.
Given solution is not worked with above selections.
eg. If I use Fortnight2,the result should be - Jan 15 2012 to 28 Jan 2013.
If I use Week2,the result should be- Jan 8 2012 to 14 Jan 2013.
So,Please suggest another solution.