Expression in qlikview

[narender123]

Hi Team,

I have to get a result like:

Sales of the persons who bought only product A.

If we have multiple persons who bought products with different categories. So i want only those persons sales who bought only product A but not product B,C, D ---

Thanks,

Narender

[MK_QSL]

Something like this

=SUM({

     <person = {"=COUNT(DISTINCT product)=1"}>

     *

     <person = {"=COUNT({<product = {'A'}>}DISTINCT person )=1"}>

}Sales)

[MK_QSL · Accepted solution]

or

=SUM({<product = {'A'}, person = {"=COUNT(Distinct product)=1"}>}Sales)

[narender123]

Thanks for your reply Manish.

Can you please explain your last one expression??

Thanks,

Narender

[Peter_Cammaert]

Sum the Sales for Product A from people who only bought one product (which by inference is product A)