Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

'Or' Statement among different fields

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?

IDAgeGenderHHI
P115-24M100-150K
P235-44F200-300K
P355+FBelow 50K
P435-44F300K+
P545-54M200-300K
P635-44F100-150K
P725-34MBelow 50K

Thanks!

_______________________________________________________________

updated with a sample data - how to make count to be either Pantene user or Dove user? Thanks a lot!

消息编辑者为:Carol Song

1 Solution

Accepted Solutions
schlettig
Contributor

Re: 'Or' Statement among different fields

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

4 Replies
sujeetsingh
Honored Contributor III

Re: 'Or' Statement among different fields

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.

Not applicable

Re: 'Or' Statement among different fields

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
Contributor

Re: 'Or' Statement among different fields

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

Not applicable

Re: 'Or' Statement among different fields

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.

Community Browser