Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
AB
Contributor II
Contributor II

QlikView OR filter using set Analysis

hi everybody, i've a question for you and i hope you could help me.
I'm trying to simulate an OR filter using set analysis but i've some problem.

this is the expression: i want to show all data with FIELD1, FIELD2 OR FIELD3 but my exp doesn't work correctly. 

if(vORFilter=1,

only(
{

< FIELD1= P({< FIELD1=,FIELD2=,FIELD3= >} FIELD1) >

+

< FIELD2= P({< FIELD1=,FIELD2=,FIELD3= >} FIELD2) >

+

< FIELD3= P({< FIELD1=,FIELD2=,FIELD3= >} FIELD3) >
}DIMENSION)
,

DIMENSION)

 

 

ty so much

 

Alessandro

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

Does this look like what you wanted?

image.png

View solution in original post

4 Replies
sunny_talwar

Would you be able to share a sample where we can see the issue?

AB
Contributor II
Contributor II
Author

in the application attached, if i select:

FIELD1 = 1

FIELD2 = 1

FIELD3 = 1

 

i expect that the value "ddd, 0, 0, 1" is displayed but, with the actual expression, it doesn't.

 

Sry for my english and ty 

 

 

Alex

sunny_talwar

Does this look like what you wanted?

image.png

AB
Contributor II
Contributor II
Author

i think it's exactly what i want!! i'm going to do some test but i'm very positive.

 

Ty so much