Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
y2021hjf
Contributor
Contributor

SUM Multiple Fields

Dear experts


I am trying to derive a percentage using the Expression below, it will display in a text object (its a visual thing).

=num(sum([field 1])+sum([field 2])+sum([field 3])/sum([field 4]),'#0%'

I get the statement 'Expression OK' but the figure I get back is neither correct in value or formatted as a %.

I am new to this, so not yet familiar with the 'language' and common methodologies - using QV 11.2

Grateful for any guidance.

Jason.

1 Solution

Accepted Solutions
sunny_talwar

You can also try this:

=Num((Sum([field 1])+Sum([field 2])+Sum([field 3]))/Sum([field 4]),'#0%')

View solution in original post

8 Replies
swuehl
MVP
MVP

Maybe

=num( Rangesum(sum([field 1]),sum([field 2]),sum([field 3]) ) /sum([field 4]),'#0%')

y2021hjf
Contributor
Contributor
Author

Thanks Stefan - but this seems return the value of Field 1 + Field 2 only.

sunny_talwar

You can also try this:

=Num((Sum([field 1])+Sum([field 2])+Sum([field 3]))/Sum([field 4]),'#0%')

View solution in original post

y2021hjf
Contributor
Contributor
Author

Perfect - Thank you Sunny - I was warned it would all be in the brackets! 🙂

Jason

swuehl
MVP
MVP

Yes, or maybe even

=num(Sum( Rangesum( [field 1],[field 2],[field 3]) ) / sum([field 4]),'#0%')


Bottom line: Take care of multiplication / division operator precedes addition operator rule, use brackets or functions to get the sum of fields right before dividing it by the denominator.

y2021hjf
Contributor
Contributor
Author

Thank you for the additional method and sound advice Stefan, very much appreciated.

swuehl
MVP
MVP

Without knowing your data model (e.g. your fields are located in different tables) and data, it's hard to tell why this is happening.

But glad you got it working.

daclarke
Contributor
Contributor

I found the following to work in QlikSense for me, using the "rangesum" replacing all "sum" and using "," instead of "+"

num(rangesum([field 1])/Rangesum(rangesum([field 2]),rangesum([field 3]),rangesum([field 4])) ,'#0%')