Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
darrin_pilkingt
Creator II
Creator II

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.

darrin_pilkingt
Creator II
Creator II
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.