topic Re: Difference between Total and ALL in QlikView

Difference between Total and ALL

Thu, 25 Jul 2013 05:23:05 GMT

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)

Re: Difference between Total and ALL

narender123 — Thu, 25 Jul 2013 05:36:05 GMT

Hi,

Please see the below link.

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

Hope this will help you

Thanks.

Re: Difference between Total and ALL

Thu, 25 Jul 2013 05:44:08 GMT

"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.

Re: Difference between Total and ALL

Thu, 25 Jul 2013 06:00:34 GMT

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.

Re: Difference between Total and ALL

Thu, 25 Jul 2013 06:26:36 GMT

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...

Re: Difference between Total and ALL

Thu, 25 Jul 2013 06:38:09 GMT

SEE ATTACHEMENT

Re: Difference between Total and ALL

Thu, 25 Jul 2013 06:41:25 GMT

how to attach qvw file ...