I am trying to choose a date in the calendar object using a variable and document trigger. Not sure what I am missing in the attached qlikview document but the value selected in the calendar is not getting reflected in the data. Please assist.
Solved! Go to Solution.
Thanks Sunny. But I want it to work just with date too without the timestamp portion. The one you gave is working fine with timestamp. Can you please help me just for the date part without timestamp. Thanks!
The attached qlikview has the same example without timestamp.
If you want to just use a date, you will have to create a field in your script which only has date (and doesn't include the time component). Something like this:
Date(Floor(TEST_EXPIRATION_DT)) as DATE_TEST
and now you can use select in field on DATE_TEST -> = '=' & DATE(vTestDt) or even this should work: =Date(vTestDt)