Dynamic List Box

albe — Mon, 10 Jan 2022 23:30:33 GMT

Hello,

I would like to create list boxes by reading an external parameter file containing the name of the fields and a flag to choose if they should be displayed in a list box.

Do you have an idea to do this ?

I tried creating a table that has the name of the fields to be displayed in list boxes, but I don't know how to choose the list box field using an expression.

Thank you for your help.

Re: Dynamic List Box

MarcoWedel — Tue, 11 Jan 2022 16:55:37 GMT

Hi,

one possible solution to this might be:

=$(=Only({$<ShowFieldID={1}>} NameOfField))

=$(=Only({$<ShowFieldID={1}>} ShowField))

Using a table containing the field names and show flags:

tabShowFields: LOAD RecNo() as ShowFieldID, * INLINE [ NameOfField, ShowField Field1, 1 Field2, 0 Field3, 1 Field4, 1 Field5, 0 Field6, 1 Field7, 0 Field8, 1 ]; tabData: LOAD Ceil(Rand()*20) as Field1, Ceil(Rand()*20) as Field2, Ceil(Rand()*20) as Field3, Ceil(Rand()*20) as Field4, Ceil(Rand()*20) as Field5, Ceil(Rand()*20) as Field6, Ceil(Rand()*20) as Field7, Ceil(Rand()*20) as Field8 AutoGenerate 30;

hope this helps

Marco

topic Re: Dynamic List Box in QlikView

Dynamic List Box

Re: Dynamic List Box