Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

dhernandez95
New Contributor

Sum function

Good day!

I made a bar graph and on measure put the following function:

= Sum ({<FAM_N_GIRO =>} AMOUNT)

And I see two bars: one for "Market" and the other for the family that I select, but in the "amount" for "market" I omit the amount of the selected family.

My question is: How can I do so that in "Market" I see the total of all families and apart from the family selected?

3 Replies
sasiparupudi1
Honored Contributor III

Re: Sum function

Please upload a sample

Re: Sum function

Might be

= Sum ({1<FAM_N_GIRO =>} AMOUNT)-sum(Amount)


If it will not help you Provide more information.


Regards,

Regards,
Prashant Sangle
thevingo
Contributor

Re: Sum function

Hi

but in the "amount" for "market" I omit the amount of the selected family

How you do that, please explain.

Now for How can I do so that in "Market" I see the total of all families and apart from the family selected?

You can try e() in SET expression as

=Sum ({<FAM_N_GIRO = e(FAM_N_GIRO)>} AMOUNT)

--please check the syntax

govind

Community Browser