topic Re: XOR Function in QlikView

XOR Function

Thu, 30 Mar 2017 22:04:17 GMT

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.

Thanks in advance

Re: XOR Function

Anil_Babu_Samineni — Fri, 31 Mar 2017 05:23:03 GMT

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

Re: XOR Function

PrashantSangle — Fri, 31 Mar 2017 05:49:35 GMT

Hi,

use "\" for XOR

For details read below thread

Implicit Set Operators

Regards,

Prashant

Re: XOR Function

Peter_Cammaert — Fri, 31 Mar 2017 06:34:08 GMT

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

Re: XOR Function

tresB — Fri, 31 Mar 2017 06:53:42 GMT

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