Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

1 Solution

Accepted Solutions
Highlighted

Re: QlikView OR filter using set Analysis

Does this look like what you wanted?

image.png

View solution in original post

4 Replies
Highlighted

Re: QlikView OR filter using set Analysis

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

Highlighted
Contributor II
Contributor II

Re: QlikView OR filter using set Analysis

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

Highlighted

Re: QlikView OR filter using set Analysis

Does this look like what you wanted?

image.png

View solution in original post

Highlighted
Contributor II
Contributor II

Re: QlikView OR filter using set Analysis

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

 

Ty so much