Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Try this:
{<College -= {0}>+<University -= {0}>}
try with +
count( {$ <College-={0}>+<University-={0}>} id_user)
Set Analysis uses Algebra, an OR cab be replaced with an union of two sets.
So <College-={0}>+<University-={0} is what you need
Hi,
How about
{<College -= {0} , University -= {0}>}
Gabriel, this will be AND, not OR:
[College]<>0 AND [University]<>0
I'm not sure how count and id_user will be used in the formula.
I tried it and it does not work. It shows 'Error in set modifier expression'. Thanks for your help
I tried it and it does not work. Thanks for your help.
Michal is right. Anyhow, I tried it and it does not work. Thanks for your help.