topic Re: Multi_selection_box: Conditional field in QlikView

Multi_selection_box: Conditional field

datanibbler — Thu, 13 Feb 2014 14:28:48 GMT

Hi,

in a multi_selection_box, how do I insert one field that should only be available dependent on the selection in another field

(=> I have two concatenated lists for 2013 and 2014, the one for 2014 having one additional field that I want to make selectable))

=> The field (and its description) should only appear when the year 2014 is selected.

=> I have made it so far that the field is available only in that case

<=> There is, however, still an inactive and non-available field in the box when 2013 is selected.

Can someone help me here?

Thanks a lot!

Best regards,

DataNibbler

marcus_sommer — Thu, 13 Feb 2014 14:42:08 GMT

Not very elegant - but if you used two multiboxes with a visibility-condition on the year-selection?

- Marcus

alexandros17 — Thu, 13 Feb 2014 14:42:15 GMT

Example:

fld1

fld2

I want to make selectable fld2 depending on one particular value of fld1

in multibox, modify fld2 as follow:

if(getfieldselection(fld1)=myValue, fld2, nul())

Hope it helps

datanibbler — Thu, 13 Feb 2014 14:46:46 GMT

Hi Alessandro,

unfortunately, that doesn't work - still, when 2013 is selected, an empty and non-available field is visible in the selection_box.

Best regards,

DataNibbler