Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

XOR Function

Hi All,

Could someone help me with this.

I have table as below. But i want to see rows to user who belong to any one AREA but not both or NULL

OutPut: B and C.

Sample.png

Thanks in advance

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

And with increasing number of Areas, you might want to make it dynamic like:

=sum({<User*={"=count({1} DISTINCT Area)<$(=count(Distinct Area))"}>} [X Sales]+[Y Sales])

View solution in original post

4 Replies
Highlighted

XOR we can use like If condition -- If(XSales >= 20 or YSales <=30, 'True','False')



Can you share sample data and expected output which demonstrates the output

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted

Hi,

use "\" for XOR

For details read below thread

Implicit Set Operators

Regards,

Prashant

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted

You can accomplish this by using set analysis and an expression search.

Your original post may not be the most detailed (your table looks like an aggregated end-result instead of a base table from which to start), but you can try with a straight table that includes dimensions User & Area, and an expression like:

=sum({<User*={"=count({1} DISTINCT Area)=1"}>} [X Sales]+[Y Sales])

See also the example in attachment

Best,

Peter

Highlighted
MVP
MVP

And with increasing number of Areas, you might want to make it dynamic like:

=sum({<User*={"=count({1} DISTINCT Area)<$(=count(Distinct Area))"}>} [X Sales]+[Y Sales])

View solution in original post