topic SUM Multiple Fields in QlikView

SUM Multiple Fields

Anonymous — Wed, 18 Jan 2017 10:19:56 GMT

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.

Re: SUM Multiple Fields

swuehl — Wed, 18 Jan 2017 10:26:06 GMT

Maybe

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

Re: SUM Multiple Fields

Anonymous — Wed, 18 Jan 2017 10:33:27 GMT

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

Re: SUM Multiple Fields

sunny_talwar — Wed, 18 Jan 2017 10:33:33 GMT

You can also try this:

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

Re: SUM Multiple Fields

Anonymous — Wed, 18 Jan 2017 10:35:11 GMT

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

Jason

Re: SUM Multiple Fields

swuehl — Wed, 18 Jan 2017 10:41:46 GMT

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.

Re: SUM Multiple Fields

Anonymous — Wed, 18 Jan 2017 10:44:32 GMT

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

Re: SUM Multiple Fields

swuehl — Wed, 18 Jan 2017 11:45:09 GMT

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.

Re: SUM Multiple Fields

daclarke — Fri, 10 Jan 2020 17:57:06 GMT

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%')