topic Storing the straight table's Total Mode of a column in a variable for later reference in QlikView

Storing the straight table's Total Mode of a column in a variable for later reference

Sat, 26 May 2012 14:40:02 GMT

Say you have a straight table containg multiple rows (using one dimension) and just one column (one expression). The formula used to arrive at the individual row values is complex [uses divisions, multiplications, set analysis]. The total of the column however is merely the sum of the rows and hence I'm setting the Total mode to "Sum of rows". Now I want this total (which appears in the top most row, above the first row) to be stored in a variable for use in other computations. How do I achieve this?

Help much appreciated.

Regards,

Gopal

Storing the straight table's Total Mode of a column in a variable for later reference

swuehl — Sat, 26 May 2012 14:47:41 GMT

You should be able to use advanced aggregation in your variable definition to achieve what you want:

In variable overview, use this expression as definition:

=sum( aggr( YourComplexExpressionFromTheTable, YourDimensionFromTheTable))

You might run into some issues if you are using chart inter record functions in your complex expression, like above(), but you haven't listed that

Storing the straight table's Total Mode of a column in a variable for later reference

Sat, 26 May 2012 15:06:25 GMT

Piece of cake! Thanks swuehl.

Re: Storing the straight table's Total Mode of a column in a variable for later reference

Thu, 28 Apr 2016 16:28:00 GMT

This was exactly what I was looking for. Thank you very much.

Re: Storing the straight table's Total Mode of a column in a variable for later reference

Monika2828 — Thu, 28 Feb 2019 06:32:17 GMT

Hi, It'd be great if you could suggest what to do if i'm using above() in my expression? TIA