topic Re: Dependent inputbox list in QlikView

Dependent inputbox list

Mon, 11 Nov 2013 14:39:34 GMT

hi everyone

I have taken two input boxes and choosed predefined list and second box is dependent on the first one

In first one i have added the expression like

=concat(distinct if([sl_date]>=makedate(2010,12,1),[sl_date]),',')

its working fine giving me all dates greater than 1 dec 2010

and i am saving its value in vsl_date variable

in second drop down

=concat( distinct if([cl_date]>= vsl_date,[cl_date]),',')

and it works fine

but some times it doesnt work . Then if i right click on the and choose apply and ok . It starts working fine

can you please help me with this issue so that i dont have to right click on second box to make it working ?

Anonymous — Mon, 11 Nov 2013 20:25:54 GMT

Hi Ashishkoul,

can you please share the test application,i think issue is when ever entering the values into input box

after you want to press the enter or click on the application then variables will be work properly.

Regards

Mon, 11 Nov 2013 20:36:15 GMT

Please show the second Input Box after any value selected in First Input Box.