topic Re: Sum all value in group in QlikView

Sum all value in group

phongnnguyen — Wed, 04 Jul 2018 04:07:56 GMT

Dear guys,

I have a problem with my set analysis. I want to sum group all value like below table:

this is my expected result:

My expression is:

aggr(sum(value),client)

But it's not work.

Thanks for help !

lironbaram — Wed, 04 Jul 2018 05:31:59 GMT

this should answer your need sum(aggr(nodistinct sum([Value]),Client))

agastya — Wed, 04 Jul 2018 05:52:23 GMT

phongnnguyen — Wed, 04 Jul 2018 06:21:11 GMT

Thanks for your help. but it is not work too.

phongnnguyen — Wed, 04 Jul 2018 06:22:05 GMT

Thanks for your consider but I dont understand what's your mean.

BalaBhaskar_Qlik — Wed, 04 Jul 2018 06:47:26 GMT

May be these:

rangesum(above(TOTAL sum(value), 0, rowno(TOTAL)))

rangesum(above(Value, 0, rowno()))

lironbaram — Wed, 04 Jul 2018 07:08:48 GMT

what do you mean it doesn't work

this was tested on the demo data and works ,

do you have additional dimensions on your table?

phongnnguyen — Wed, 04 Jul 2018 07:23:06 GMT

Hi Liron Baram,

Sorry about this information, i just have tested your code, and it works with me.

Thanks for your help so much