topic Re: Expression in qlikview in QlikView

Expression in qlikview

narender123 — Mon, 09 Apr 2018 08:09:43 GMT

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

Re: Expression in qlikview

MK_QSL — Mon, 09 Apr 2018 09:12:10 GMT

Something like this

=SUM({

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

}Sales)

Re: Expression in qlikview

MK_QSL — Mon, 09 Apr 2018 09:16:33 GMT

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

Re: Expression in qlikview

narender123 — Mon, 09 Apr 2018 13:18:19 GMT

Thanks for your reply Manish.

Can you please explain your last one expression??

Thanks,

Narender

Re: Expression in qlikview

Peter_Cammaert — Mon, 09 Apr 2018 13:31:36 GMT

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