topic Re: or selection in QlikView

or selection

yelin_nyu — Tue, 03 Dec 2013 23:33:38 GMT

to make example easy to understand:

i have 2 independent flags: A & B used as list box selections on screen, users can choose A or/and B to see different issues. without selection, user can see everything. i have trouble to let user to select the 2 flags and get records with either/or issues.

*i have 10 flags in my report. this is for a issue identification report, each record can have many different issues, each flag could act as a filter... how do i do a "OR" selection?

prod site flag A flag B

123 P 1 0

xxx Y 0 1

uys O 1 1

777 T 0 0

if i select A=1, then reco 1,3 appear

if i select B=1, then reco 2,3 appear

if i select A=1, B=1, then reco 3 appears

How do i get 1,2,3 to appear by select on both A and B list box?

Re: or selection

Tue, 03 Dec 2013 23:40:22 GMT

Can you have 2 list boxes? If so you can control with 2 alternate states. In the expression, you can choose to use the alternate state to suit your needs. e.g. in your 3rd condition you can use the union of the 2 alternate states.

Re: or selection

yelin_nyu — Tue, 03 Dec 2013 23:45:13 GMT

but I have more than 10 flags in my report, an user can potentially choose flag 1,3, 6, 9, 11 or flag 2,8 or flag 4, 5,12... the combination is pretty much endless. i can't really create a separate list box for each combination, that's too many