Discussion Board for collaboration related to QlikView App Development.
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.
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.
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%')