Set Analysis two field filter where either of them should be true

[#1]

Hi all,

I have two field that would serve me as Filter, ART_GRP and CUST_GRP, i need Set Analyse where (ART_GRP=1 or CUST_GRP=5),

Is it posible to write it like that in Expresion field or somewhere?

I am new to Qlick view so please help.

BR,

Ivan

[jonathandienst · Accepted solution]

Hi

Something like this:

{<ART_GRP = {1}> + <CUST_GRP = {5}>}

Hope that helps

Jonathan

[manideep78]

Yes,

But you can use set analysis for aggregation functions like count(), sum()...

So what do you want to find with the help of below condition?

[#4]

Thank you Jonathan,

That was i manage, i put agregation per those two field:

sum ({$<ART_GRP = {1}> + <CUST_GRP = {5}>} izn_dug-izn_pot)

I get correct answer, now could play with dimensions.

Thank you again.

BR

Ivan