topic 'Or' Statement among different fields in QlikView

'Or' Statement among different fields

Mon, 02 Dec 2013 03:26:55 GMT

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

Re: 'Or' Statement among different fields

sujeetsingh — Mon, 02 Dec 2013 04:26:12 GMT

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.

Re: 'Or' Statement among different fields

Mon, 02 Dec 2013 08:28:41 GMT

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?

Re: 'Or' Statement among different fields

schlettig — Mon, 02 Dec 2013 09:57:23 GMT

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

Re: 'Or' Statement among different fields

Mon, 02 Dec 2013 13:40:24 GMT

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.