Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

XOR operator "/"

Someone already used the XOR operator set analysis?

I am wanting to compare a field as follows: field1 = 99999999 or> data

1 Solution

Accepted Solutions
erichshiino
Partner - Master
Partner - Master

Hi, Gleybson

I'm not sure I understood the way you want to use it.

You can use operations between sets like this:

sum ( { <field1={9999}> + <field1 = {">500000"} >  } Value )

It means that field1 is equal to 9999 or ( + ) field1 > 500,000

You can create any condition in set1 and set2 and any operation ( +, *, -, / ) between them.

Hope it helps,

Erich

View solution in original post

1 Reply
erichshiino
Partner - Master
Partner - Master

Hi, Gleybson

I'm not sure I understood the way you want to use it.

You can use operations between sets like this:

sum ( { <field1={9999}> + <field1 = {">500000"} >  } Value )

It means that field1 is equal to 9999 or ( + ) field1 > 500,000

You can create any condition in set1 and set2 and any operation ( +, *, -, / ) between them.

Hope it helps,

Erich