topic Re: QlikView OR filter using set Analysis in QlikView

QlikView OR filter using set Analysis

AB — Sat, 16 Nov 2024 02:26:54 GMT

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

Re: QlikView OR filter using set Analysis

sunny_talwar — Wed, 18 Sep 2019 14:08:01 GMT

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

Re: QlikView OR filter using set Analysis

AB — Wed, 18 Sep 2019 14:39:09 GMT

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

Re: QlikView OR filter using set Analysis

sunny_talwar — Wed, 18 Sep 2019 15:03:18 GMT

Does this look like what you wanted?

Re: QlikView OR filter using set Analysis

AB — Wed, 18 Sep 2019 15:06:45 GMT

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

Ty so much