Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Row total

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.

error loading image

4 Replies
Miguel_Angel_Baeyens

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.

Not applicable
Author

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

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.

Not applicable
Author

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"

Angel+Beer+Coffee+Drinks