range selection through input box

[Anonymous]

Hi experts!

I have created a trigger on Field Date that sets the value for two variables vStartDate = Min(Date) and vEndDate=Max(Date). When I select different range in listbox Date, the value for variables do not change in input box. I am not able to figure out where I am making mistake. Could you please help.

Please find the app attched.

Thanks!

[ramoncova06]

I assume you created the variables from within the input box and that causing the conflict, it started working once I removed them and added them back in variable overview

[Anonymous]

Oh Really...I try again

[Anonymous]

Thanks! that worked. I was trying to create trigger on Date so that it selects range in listbox. I have used this expression ='>=' & vStartDate & '<=' & vEndDate but seems for end date it is not selecting the = (last date), it is just selecting <.

Please find the app attached.

[ramoncova06]

this should cover what you are trying to do

QlikView App: Dates, Date Ranges and Set Analysis

[Anonymous]

I feel that I am doing the right thing but not getting the right output. You can see my app attached. I have used same expression for creating trigger on Start Date and End Date but only in the case of End date it is not including the maximum date or latest date, it just selects everything less than maximum date and graeter than or equal to minimum date.

='>=' & vStartDate & '<=' & vEndDate