topic Row total in QlikView

Row total

Tue, 14 Sep 2010 11:47:16 GMT

Hi All,

I want to to calculate the row total as show in the picture. Please let me know how to do the same as shown in the picture.

i,e: 1+2+3+4 = 10 as total.

Miguel_Angel_Baeyens — Tue, 14 Sep 2010 11:57:49 GMT

Hello Rikab,

Having A, B, C and D as expressions, you may create a new one with the following code

"A" + "B" + "C" + "D"

EDIT: I use to enclose expression names in "[" and "]" instead of double quotes but they are rendered as icons in the post.

Regards.

Tue, 14 Sep 2010 12:29:55 GMT

Hi Miguel,

Thank you so much!

I used both of this and seems to be working fine. Is there is any difference between this two?

A+B+C+D

and

"A"+"B"+"C"+"D"


Miguel A. Baeyens wrote:EDIT: I use to enclose expression names in "[" and "]" instead of double quotes but they are rendered as icons in the post.

But the above doesn't seems to be working.

I used like below and it doesn't seems to be working

[code["["A"]"+"["B"]"+"["C"]"+"["D"]"

Miguel_Angel_Baeyens — Tue, 14 Sep 2010 12:41:34 GMT

Rikab,

It's just a personal view. If it's working with double quotes, that's fine, use that. I only mean I'd use

[Expression1] + [Expression2]

instead of

"Expression1" + "Expression2"

although both might return the same.

Regards.

Tue, 14 Sep 2010 12:55:54 GMT

Hi Miguel,

Many thanks to you! All the below 3 method works for row total. Have attached the working document for others reference.


A+B+C+D

"A"+"B"+"C"+"D"

+++