topic Re: SUM expression question in QlikView

SUM expression question

Anonymous — Wed, 09 Dec 2015 19:31:15 GMT

Hi,

I was looking at an app that someone developed. One of the charts has this expression:

= sum({<_RevenueFlag-={1}>} TransactionAmountInDollars)

I believe it means sum the TransactionAmountInDollars where _RevenueFlag = 1. However I noticed there is what

appears to be a minus or hyphen symbol between _RevenueFlag and the equal sign. Can someone explain what that

means or what this expression maybe doing?

Thanks

Re: SUM expression question

sunny_talwar — Wed, 09 Dec 2015 19:34:34 GMT

It means sum TransactionAmountInDollars where _RevenueFlag is not equal to 1

Re: SUM expression question

Anonymous — Wed, 09 Dec 2015 19:42:22 GMT

Sunny, thanks for the quick response. Personally I would coded it as _RevenueFlag = (0) since it can only be

0 or 1. This is much clearer.

Re: SUM expression question

sunny_talwar — Wed, 09 Dec 2015 19:45:50 GMT

I agree. Its much more easier to understand

Re: SUM expression question

maxgro — Wed, 09 Dec 2015 19:50:48 GMT

All _RevenueFlag of the selection except -1

Re: SUM expression question

Anonymous — Wed, 09 Dec 2015 19:53:19 GMT

maxgro,

Can you please explain what "except -1" mean? I have only been working with QV for a few weeks.

Thanks

Re: SUM expression question

Anonymous — Wed, 09 Dec 2015 20:01:54 GMT

-1 is excluded, so you will see everything else.

Re: SUM expression question

maxgro — Wed, 09 Dec 2015 20:03:01 GMT

<F1=-{a}> is b, c

<F1-={a}> is selected -a, --> b

you can find in

Set Analysis: syntaxes, examples

Re: SUM expression question

effinty2112 — Wed, 09 Dec 2015 22:17:56 GMT

Hi Sidney,

We need to be a bit careful here, the expression

= sum({<_RevenueFlag-={1}>} TransactionAmountInDollars)

will not include in the calculation records that have RevenueFlag = 1 or that have null RevenueFlag. In your case as the flag is always non-null this is not a consideration but it should be bourne in mind.

If I can use your example as an illustration, if some of your records had null RevenueFlag and you wanted to sum up all that were not set to 1 in this field then the expression

= sum({$-<_RevenueFlag={1}>} TransactionAmountInDollars)

would include the records in the default selection state with null RevenueFlag and also non-nulls <> 1.

Re: SUM expression question

Anonymous — Thu, 10 Dec 2015 13:41:35 GMT

Thanks Andrew and others who responded. I will need to go through these samples myself to see how the results come out when I play around with this expression.