Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
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
tresesco
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
Anil_Babu_Samineni

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)
PrashantSangle

Hi,

use "\" for XOR

For details read below thread

Implicit Set Operators

Regards,

Prashant

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

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

tresesco
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])