Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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