topic sum equal values in QlikView

sum equal values

Thu, 13 Mar 2014 20:55:36 GMT

I want to sum two identical values in the same column, the value is five, what should I do so that when I to sum the two values the result be equal ten and not five.

Re: sum equal values

its_anandrjs — Thu, 13 Mar 2014 21:15:22 GMT

Hi,

Can you provide any data file.

Thanks & Regards

Re: sum equal values

Thu, 13 Mar 2014 21:19:51 GMT

ie:

user num value

1 5

2 5

the result should be 10, but qlik show 5

Re: sum equal values

its_anandrjs — Thu, 13 Mar 2014 21:25:04 GMT

Hi,

Which chart you use let me know

and use dimension -> user num

Expression -> Sum(value)

Hope this helps

Thanks & Regards

Re: sum equal values

Thu, 13 Mar 2014 21:30:57 GMT

I did so but the result is five and should be 10, when the values are equal, no sum the two values, result sets the value of one