topic use total sum in Pivot in QlikView

use total sum in Pivot

Mon, 09 Jan 2012 14:33:09 GMT

Hello Guys,

I hope you can help me.

how can i use the red marked field in my expression:

if(red_field>0,sum(value))

(gesamt=total)

Kind Regards,

Lukas

use total sum in Pivot

swuehl — Mon, 09 Jan 2012 14:48:54 GMT

Lukas,

it looks like you are using four dimensions and one expression, right?

So if you expression looks like

=sum( ExpressionValue)

then try

=sum(TOTAL ExpressionValue)

to retrieve the overall total value (I assume that is your Gesamt value outlined in red).

Then try

= if(sum(TOTAL ExpressionValue) >0, sum( AnotherValue))

Hope this helps,

Stefan

use total sum in Pivot

Mon, 09 Jan 2012 15:07:08 GMT

hi Stefan,

i think my example is not so good, here another example.

Its not always the Total value.

I've tried something with dimensionality ( ) = 1 but it also doesn't work.

any ideas?

Re: use total sum in Pivot

swuehl — Mon, 09 Jan 2012 15:13:07 GMT

Try TOTAL qualifier with field / dimension list:

=sum(TOTAL<Dimension1> ExpressionValue)

(or specify all the Dimensions you need to consider for your total sum, sum(TOTAL<Dimension1, Dimension2> ExpressionValue) )

But this will only return the total in the same context of Dimension1, i.e. you can't refer the same subtotal for all lines (lines that belong do different Dimension1 values). Do you need something like this?

use total sum in Pivot

Tue, 10 Jan 2012 08:21:19 GMT

thank you 🙂

now it works.