Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Date variable allows calendar picker in one app but not another

I have created DateFrom and DateTo variables to default the range of dates displayed in the calendar pickers based on today's date.  I still wanted the end user to be able to change that date.  In one app it works as expected and in another, with the same code it does not.

Any thoughts.

Calendar:

load

         Date(SalesPriorMthEndDt + 1) as SalesMthStartDt,

             SalesMthEndDt

FROM

[..\..\ExtractQVD\Calendar\SalesCalendar.qvd]

(qvd)

where DayID = Today();

LET DateFrom = PEEK('SalesMthStartDt');

LET DateTo = PEEK('SalesMthEndDt');

DROP Table Calendar;

The app that does not allow a calendar change only gives me the year 1899 and 1900 option.

Calendar.jpg

Thanks for any help.

1 Solution

Accepted Solutions
tresesco
MVP
MVP

use max and min functions to get the maxdate and mindate in two fields and then use peek function to get the values into the variables. that should resolve your issue.

View solution in original post

2 Replies
tresesco
MVP
MVP

use max and min functions to get the maxdate and mindate in two fields and then use peek function to get the values into the variables. that should resolve your issue.

Anonymous
Not applicable
Author

Tres, thank you. 

I had just realized that on this particular app it defaulted in a Min = 0 and a Max = 10 but not on the other apps.

I removed that and it worked as the others.