Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to build List Box/Boxes where the users can make selection based on 'Or' statement from different fields. For example, to get count for IDs who are Male or HHI $200K+? Since there are so many fields that the users can dynamically select and build the target from, I can't create new fields to include 'Or' expression in - there's no way to exhaust the possible combinations. What should I do?
ID | Age | Gender | HHI |
P1 | 15-24 | M | 100-150K |
P2 | 35-44 | F | 200-300K |
P3 | 55+ | F | Below 50K |
P4 | 35-44 | F | 300K+ |
P5 | 45-54 | M | 200-300K |
P6 | 35-44 | F | 100-150K |
P7 | 25-34 | M | Below 50K |
Thanks!
_______________________________________________________________
updated with a sample data - how to make count to be either Pantene user or Dove user? Thanks a lot!
消息编辑者为:Carol Song
Hi,
i've found the following genious idea in the blogosphere 🙂
http://http://www.qlikfix.com/2013/10/23/and-or-mode-selections-in-qlikview/
Maybe that helps?
Best regards,
Christian
Carol i have made the selection option in the below sample see the expression of the Staraight Table.
I have used nested if() statement . Even you can use set analysis too.
Thanks for the reply! But I have hundreds of fields and there are millions of possible combinations of these fields, is there a dynamic way to build the or statement?
Hi,
i've found the following genious idea in the blogosphere 🙂
http://http://www.qlikfix.com/2013/10/23/and-or-mode-selections-in-qlikview/
Maybe that helps?
Best regards,
Christian
You can create the expressions dynamically by using variables and these variables get changes based on user selections.
Can you please post some more data with more dimensions and some complex requirement (post what some examples to expect the expression ) so community people will help more.