topic Re: Set analysis for sales in QlikView

Set analysis for sales

aaronnayan — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys

I need an expression to exclude a certain value from the selected field whilst calculating sales

Can you help?

the field is "Advisors"

the value is "BOB"

Sales field is "SALES"

Thankyou guys

devarasu07 — Thu, 17 Aug 2017 08:53:48 GMT

Try like this,

sum({<Advisors-={'BOB'}>}Sales)

avinashelite — Thu, 17 Aug 2017 08:54:41 GMT

try like this

sum({<Advisors={"*"}-{'BOB'}>}Sales)

devarasu07 — Thu, 17 Aug 2017 08:57:47 GMT

Hi,

PFA basics set analysis PDF document may be useful for you.

Anonymous — Thu, 17 Aug 2017 08:57:59 GMT

or this:

sum({$-<Advisors={"BOB"}>} Sales)

Anonymous — Thu, 17 Aug 2017 08:59:30 GMT

Hello,

Try this:

sum({<Advisors=e({1<Advisors={"BOB"}>})>}Sales)

Regards

Jacek.

sam_grounds — Thu, 17 Aug 2017 09:22:16 GMT

Yeah, I can confirm this totally works, however syntax highlighting doesn't like it and you'll get the dreaded red squiggly underline!

If you want a syntax friendly version try sum({$-$<Advisors={'BOB'}>}Sales).