topic Re: Dynamic list box in QlikView

Dynamic list box

Anonymous — Fri, 09 May 2014 14:59:04 GMT

I only want a list box to appear on the selection of a value in another list box?

i.e ListBox1 contains all the Warehouses

ListBox 2 with Warehouse Locations only appear on the selection of the raw material warehouse

Re: Dynamic list box

alexandros17 — Fri, 09 May 2014 15:05:31 GMT

You have to trigger the field in this way:

Go on Settings -> document properties -> triggers

in the field event triggers box select your field and add extion -> external -> set variable

write in the upper box vShow and in the lower box write 1

Now in the script you need to define the varible in this way: LET vShow=0; and reload your document.

The last thing, the secon list box must be conditioned to be shown only if vShow=1 so go in layout -> conditional and write vShow=1

Let me know

Re: Dynamic list box

Jason_Michaelides — Fri, 09 May 2014 15:36:07 GMT

I would not use a trigger here - they can be difficult to manage. Instead, consider using a Show Condition on the Warehouse Locations that looks like GetSelectedCount(Warehouses)>0

Hope this helps,

Jason

Re: Dynamic list box

Anonymous — Tue, 13 May 2014 09:49:20 GMT

Thank you!