'Or' Statement among different fields

[#1]

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

[sujeetsingh]

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.

[#3]

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?

[schlettig · Accepted solution]

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

[#5]

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.