Solved: 2 fields not equal to 0 in set analysis - Qlik Community

Anonymous · ‎2015-04-27

How do i write the following statement in set analysis?

[College]<>0 or [University]<>0

[College]<>0

is

[College]-={0}

in set analysis. But how about 2 fields using the OR statement to be equal to 0. I am new here and appreciate the help. Thanks.

Anonymous · ‎2015-04-28

Here is how I solved it. Instead of using the OR operator between the fields, I put the individual fields in the formula, replicated it and put OR in between the formulas.

Here is an example:

<formula

,[College]-={0}

formula>

+

<formula

,[University]-={0}

formula>

The Qlikview syntax checking mechanism is only accurate until a certain extent. In complex formulas like the one I was implementing, it showed error but worked. I appreciate all your guys suggestions and hope this would help others who would encounter a similar issue as me.

View solution in original post

sunny_talwar · ‎2015-04-27

Try this:

{<College -= {0}>+<University -= {0}>}

maxgro · ‎2015-04-27

try with +

count( {$ <College-={0}>+<University-={0}>} id_user)

Clever_Anjos · ‎2015-04-27

Set Analysis uses Algebra, an OR cab be replaced with an union of two sets.

So <College-={0}>+<University-={0} is what you need

Gabriel · ‎2015-04-27

Hi,

How about

{<College -= {0} , University -= {0}>}

Anonymous · ‎2015-04-27

Gabriel, this will be AND, not OR:

[College]<>0 AND [University]<>0

Anonymous · ‎2015-04-28

I'm not sure how count and id_user will be used in the formula.

Anonymous · ‎2015-04-28

I tried it and it does not work. It shows 'Error in set modifier expression'. Thanks for your help

Anonymous · ‎2015-04-28

I tried it and it does not work. Thanks for your help.

Anonymous · ‎2015-04-28

Michal is right. Anyhow, I tried it and it does not work. Thanks for your help.