topic range selection through input box in QlikView

range selection through input box

Anonymous — Tue, 16 Jun 2015 18:25:54 GMT

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!

Re: range selection through input box

ramoncova06 — Tue, 16 Jun 2015 18:37:37 GMT

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

Re: range selection through input box

Anonymous — Tue, 16 Jun 2015 18:40:43 GMT

Oh Really...I try again

Re: range selection through input box

Anonymous — Tue, 16 Jun 2015 19:18:01 GMT

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.

Re: range selection through input box

ramoncova06 — Tue, 16 Jun 2015 19:20:36 GMT

this should cover what you are trying to do

QlikView App: Dates, Date Ranges and Set Analysis

Re: range selection through input box

Anonymous — Tue, 16 Jun 2015 19:29:46 GMT

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