topic Re: Conditionnal object in QlikView

Conditionnal object

Mon, 08 Sep 2014 06:41:12 GMT

Hello,

I want a selection to appear only when another selection is made in another selction box. For example, when a country is selected, I would like a slection box to appear with several cities. I used the function "match":

match(Country, 'USA')

but since it counts 3 letters, if the country equals to 'CA' or 'AU', the second selection box seems to appear while it's not the right country 😕

I tried using function with "mid" or "left saying the name should include 2 or 3 letters, but it doesn't help 😕

Thanks!

Re: Conditionnal object

datanibbler — Mon, 08 Sep 2014 06:54:51 GMT

Hi,

try using Getfieldselections([Country]) to set up a visibility_condition for your listbox.

(without the square brackets of course)

Re: Conditionnal object

Mon, 08 Sep 2014 07:03:12 GMT

Hi,

so I have now : match(Getfieldselections(Country), 'CA') and it only appear when the selection is 'CA' or when there is no selection made 😕