topic Re: Set variables based on check box in QlikView

Set variables based on check box

Anonymous — Fri, 04 Mar 2016 19:06:10 GMT

Hi Everyone,

I have a listbox with 2 values which I have set up as a check box. Is it possible to set the value of a variable based on whether or not a line in the check box is checked?

Basically, when the first line is checked off, I want variable 1 to take some value, and when the second line is checked off I want variable 2 to take a separate value.

I've messed around with GetCurrentSelections, Match, and Concat but am not having any luck. A sample qvw file is attached.

Thanks!

Michael

Re: Set variables based on check box

sunny_talwar — Fri, 04 Mar 2016 20:19:38 GMT

Check if the attached helps

Variables

1) =If(SubStringCount(GetFieldSelections(CheckBox), 'Some_Text1') = 1, 'Hi World')

2) =If(SubStringCount(GetFieldSelections(CheckBox), 'Some_Text2') = 1, 'Bye World')

Re: Set variables based on check box

Anonymous — Fri, 04 Mar 2016 20:22:01 GMT

Perfect. That seems to be exactly what I am looking for.

Thanks!

Re: Set variables based on check box

sunny_talwar — Fri, 04 Mar 2016 20:45:57 GMT

Awesome