topic Pass user input date variables to current selections to pull range of dates in QlikView

Pass user input date variables to current selections to pull range of dates

Thu, 01 Sep 2011 18:38:36 GMT

I have two user input variables vMinDate and vMaxDate. I currently have the variables in the expressions for each object.

Is there a way to pass these variables to the current selections so that I don't have to set in expression. The selection result would be: END_DATE is >= vMinDate and <= vMaxDate. Also how do i get the date input to default to M/D/YYYY if the user inputs 8/9 then enter - I want it to default to 8/9/2011

Pass user input date variables to current selections to pull range of dates

fosuzuki — Fri, 02 Sep 2011 10:49:41 GMT

Hi,

I think you could use the OnInput trigger of the variables and add a 'Select in Field' action.

And I don't think it is possible to default a 8/9 input to a 8/9/2011. Lets wait for other opinions...

Hope this helps you.

Regards,

Fernando

Pass user input date variables to current selections to pull range of dates

SunilChauhan — Fri, 02 Sep 2011 10:57:07 GMT

use Calender object

one fr Min value and other for max value

use variables inside calender to seleect ur range

hope this help you