Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have a from and to calendar object created using slider/calendar object.I am using a script to select max date value and min date value from table.When i am selecting the date from calendar the corresponding date values are not showing in the current selection box.Below i have attached my sample qlikview file
1. Your UserDate field doesn't contain proper data values. There are text values too.
2. The min and max settings for the calendar objects are not correct. They use the variable values themselves. Try =min({1}UserDate) and =max({1}UserDate) instead
3. You didn't add Select in Field actions to the OnInput triggers of the vMinDate and vMaxDate variables.
See this video tutorial for a complete demonstration: Selecting Arbitrary Date Ranges
1. Your UserDate field doesn't contain proper data values. There are text values too.
2. The min and max settings for the calendar objects are not correct. They use the variable values themselves. Try =min({1}UserDate) and =max({1}UserDate) instead
3. You didn't add Select in Field actions to the OnInput triggers of the vMinDate and vMaxDate variables.
See this video tutorial for a complete demonstration: Selecting Arbitrary Date Ranges
hi gwassenaar thank you for the help
Hi i have another doubt not sure whether it is possible,since we show date using a condition
"= '>=''from' &vMinDate & '<=' &vMaxDate " when selecting date the current selection box also shows range. for example ">=12/02/2011 <=10/03/2014". So is possible to show date range as "from 12/02/2011 to 10/03/2014 "a more end user friendly way.
Yes, in a Text Box, but not in a Current Selections box.