topic Re: Multiple selection on a field through more subfield in QlikView

Multiple selection on a field through more subfield

nboccassini — Thu, 25 Jan 2018 14:05:29 GMT

I have these data (and other fields in this table):

Category	Name
L1	A
L1	B
L2	C
L2	D

I need to make two list box (one for L1 and one for L2) and I need the selections goes in OR mode.

Is it possible?

Thx

Re: Multiple selection on a field through more subfield

petter — Thu, 25 Jan 2018 16:18:53 GMT

So L1 should only contain the two values A and B

and L2 should only contain the two values C and D?

Re: Multiple selection on a field through more subfield

nboccassini — Thu, 25 Jan 2018 16:50:07 GMT

Yes,

I try the expression in listbox

=if(Category='L1',Name)

I have a selection issue: when I select A from listbox L1, the selection are correctly applied on field Name, but when I select a value from L1 listbox (ex. A) and a value from L2 listbox (ex. B) the only selection applied on field Name is "B"

Re: Multiple selection on a field through more subfield

petter — Thu, 25 Jan 2018 17:08:34 GMT

"Alternate States" could be a solution for you. But without knowing how you will use or apply the selections in you application it is a bit hard to give good advice.

Alternate States ‒ QlikView