topic Re: List Sum in QlikView

List Sum

Wed, 26 Mar 2014 02:40:46 GMT

Hi, ALL

I have a list of column1.no and column2.price.

and want to calculate prices compare to some standard.

I hope get sum of no 3,4,5.

if i use ' sum(if(no >=3, price))', QlikView give me just sum of no.3.

I want 3100(sum of no.3,4 and 5).

thank you.

Re: List Sum

chiru_thota — Wed, 26 Mar 2014 02:50:48 GMT

use this

sum({<no={3,4,5}>}Price)

sum({<no= {'>=$(=(3))'}>}Price)

Re: List Sum

Wed, 26 Mar 2014 03:00:00 GMT

PFA.

Thanks,

Ram

Re: List Sum

SunilChauhan — Wed, 26 Mar 2014 03:00:51 GMT

use below

sum({<no={">=$(=3)"}>}price)

this will give you dynamic result if you add more No 6,7,8,9........

hope this help

Re: List Sum

Wed, 26 Mar 2014 04:11:04 GMT

thank you, Chiranjeevi Thota!!!!!

I have one more..

then, if i want a selected value, how can?

sum({<no= {'>=$(=('something'))'}>}Price)

like this?

is it 'blank' instead of 'Value'?

Re: List Sum

Wed, 26 Mar 2014 04:32:14 GMT

thank you, Sunil Kumar Chauhan!

yes, that's right.I want more dynamic like you mean.

I have one more question.

then, if i want a selected value, how can?

sum({<no= {'>=$(=('something'))'}>}Price)

like this?

is it 'blank' instead of 'Value'?

thx.

Re: Re: List Sum

Wed, 26 Mar 2014 04:49:28 GMT

Like this

Create a va riable like vOption = Max(No)

and your expression is

=SUM({<No={">=$(vOption)"}>}Price)

Re: List Sum

Wed, 26 Mar 2014 05:02:30 GMT

hi, Ravi.

I' doing as your solution.

but not working.

and I mean if i select '3' in no list box, sum of 3,4,5 appear.

select '2', sum of 2,3,4,5

select '4', sum of 4,5

.. like this. right your expression?

Re: Re: List Sum

Wed, 26 Mar 2014 05:05:35 GMT

Check the attached one