Difference between Total and ALL

[#1]

Can someone help me to understand the difference between TOTAL  & ALL  qualifiers . both of them gives different results

round(sum(Quantity)/sum(Total Quantity)*100) 

round(sum(Quantity)/sum(ALL Quantity)*100)

[narender123]

Hi,

Please see the below link.

http://community.qlik.com/message/336161#336161

Hope this will help you

Thanks.

[#3]

  "All" disregards selections, and, if used, in chart, dimensions.  It is the same as

function({1} total field)

"Total" does not disregard selections, but it disregards dimensions.  Which is applicable if you use it in chart.

[#4]

Hi,

when we using in chart

sum(All Sales) returns aggregated sales irrespective of any dimension and any selection.It will not consider any dimension values.

sum(Sales)/sum(total Sales) returns the share within the selection.for calculating percentage for a single dimension we are using this expression.

[#5]

I've attached the image here ... I got 100% when I use Total , whereas if you look at the 3rd chart

it returns 6  (I used this formula round(sum(Quantity)/sum(ALL <DivisionName>Quantity)*100)   this is where I got confused as to what basis it returns 6...

[#6]

SEE ATTACHEMENT

[#7]

how to attach qvw file ...