topic Re: PROBLEM OF DIFFERENCE OF SUM in Qlik Learning Discussions

PROBLEM OF DIFFERENCE OF SUM

bbmmouha — Mon, 02 Mar 2015 10:26:59 GMT

i have a problem and i need help

i'm a debutant

i have a dimension that contain products for exemple A B C D E F

i want to see the difference between the two products that he selected

for exemple if he selected A B

sum(A) - sum(b)

if he selected A C

sum(A) - sum(C)

thanks for help

MK_QSL — Mon, 02 Mar 2015 10:42:37 GMT

Kindly don't raise same question more than once..

oknotsen — Mon, 02 Mar 2015 21:03:23 GMT

Use "alternate states". Create two listboxes for Products, one of them in an alternate state.

= sum({$} Sales) - sum(({AlternateState} Sales)

bbmmouha — Tue, 03 Mar 2015 09:25:17 GMT

it works thanks a lot

but i want to add a dimension take into account like group product sum(({AlternateState} (G_product) Sales)

oknotsen — Wed, 04 Mar 2015 13:07:21 GMT

Something like this?

= sum({$} Sales) - sum(({AlternateState < G_product = $::G_product> } Sales)

bbmmouha — Wed, 04 Mar 2015 16:28:10 GMT

thanks a lot

you are the best

finally it's like this

=sum({[$]}NBR_VOTE) - sum({groupe2 <LIB_ELECTION=$::LIB_ELECTION>}NBR_VOTE)

but can you explain more the expression