What is the difference in usage of 'ALL' vs. 'TOTAL'

[evan_kurowski]

Can anyone explain to me the proper situations in which you would use 'ALL' vs. 'TOTAL' in expressions?

It seems to me that these two keywords seem to interchange and swap scenarios in which they are appropriate.

I use Max(TOTAL Field) in one circumstance and I get a selection that ignores all selections and returns the global maximum, and then in different circumstances I get results that are the Maximum for just what is in selection.

Do these two keywords have some sort of mobius, loop back on themselves functionality?  Just looking for a clear and fixed definition of their usage.

[Anonymous · Accepted solution]

Hello Qlik Community Members- this discussion has been answered previously but accidentally deleted we are recreating the thread. Here are the responses:

Correct Answerby Michael Solomovich on Apr 16, 2013 1:38 PM

Evan,

They are different.  "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.

Regards,

Michael

Edit: see "Examples of Aggregate Qualifiers" in QV help.  They use "{1} total" in examples, but "all" should still work.

----------------------------------------------

• EvanKurowski Apr 16, 2013 2:13 PM (in response to Michael Solomovich)
• Re: What is the difference in usage of 'ALL' vs. 'TOTAL'

So if I'm using an expression in a  text box....  the 'TOTAL' qualifier does nothing.  Essentially using "function( TOTAL field)" does no filtration different from "function(field)"?

In a text box, I have two choices for getting the global level and that is:

function( {1} field)

function(ALL field).

The usage of TOTAL only applies to chart objects and buttons?

-------------------------------------------

Michael Solomovich Apr 16, 2013 2:17 PM (in response to EvanKurowski)

I'd say that TOTAL applies only to the objects that have dimensions.  That is charts, except there could be charts without dimensions too.

[MK_QSL]

Keywords : TOTAL, ALL & DISTINCT