Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How Can I change report date (from date and to date) on the basis of Calendar date

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

2 Replies
Gysbert_Wassenaar

You could use monthstart(min([Transaction Date])) instead of just min([Transaction Date]) in the expression that displays the reporting range.


talk is cheap, supply exceeds demand
Not applicable
Author

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.