topic Re: Selection Logic in QlikView

Selection Logic

vanderson009 — Wed, 04 Mar 2015 10:38:49 GMT

Hi guys,

I have 2 listbox. As listbox1 and listbox2.

listbox1 having values like a,b,c and listbox1 having values like 1,2, 3 respectivaly

If i click on "a" then want output in text box as like 1

If i click on "b" then want output in text box as like 2

If i click on "c" then want output in text box as like 3

Thanks in advance

--Regards,

Villyee

Anonymous — Wed, 04 Mar 2015 10:43:33 GMT

try with this expression in your text box:

=if(only(abcField)='a', 1, if(only(abcField)='b', 2, if(only(abcField)='c', 3)))

abcField is the name of the field used in your listbox1.

Marc.

sunny_talwar — Wed, 04 Mar 2015 10:44:46 GMT

May be like this? PFA

Best,

Wed, 04 Mar 2015 10:48:58 GMT

List box will work with data association, so if that's the relationship between Field 1 and Field 2 then it will populate that.