Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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
Partner - Champion III
Partner - Champion III

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.