Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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 (4)
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