topic Re: Moving Totals to a variable in QlikView

Moving Totals to a variable

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have a fully working chart with two results, Wins and Lost. the values are correct and my problem is

that I would like to have the Total in an variable so I can uset it in an KPI-object .

The calculation for the Win is:

When I put this into a variable and show it in the KPI-object it shows 0.

kindly

Håkan

MK9885 — Tue, 22 Nov 2016 15:27:41 GMT

do not use = before your expression.

Just start with If condition.

sunny_talwar — Tue, 22 Nov 2016 15:36:06 GMT

You might need to add Sum(Aggr()) function

Sum(Aggr(

YourExpressionForWin, YourChartDimensions))

Wed, 23 Nov 2016 08:51:36 GMT

Good morning,

how shall I place aggr(), for each sum or one for the whole calculation?

=if ( Sum({$<$(vSetRolling12),[BudgetSegment]={"Glas"}>} $(vNettoFörs)) >= $(vOmsG) and

Sum({$<$(vSetPreviousMonth),[BudgetSegment]={"Glas"}>} $(vNettoFörs)) < $(vOmsGMonth) and

Sum({$<$(vSetMTD),[BudgetSegment]={"Glas"}>} $(vNettoFörs)) >= $(vOmsGMonth) ,1,0)

sunny_talwar — Wed, 23 Nov 2016 10:26:39 GMT

Just one for the whole calculation

Sum(Aggr(

If(Sum({$<$(vSetRolling12),[BudgetSegment]={"Glas"}>} $(vNettoFörs)) >= $(vOmsG) and

Sum({$<$(vSetPreviousMonth),[BudgetSegment]={"Glas"}>} $(vNettoFörs)) < $(vOmsGMonth) and

Sum({$<$(vSetMTD),[BudgetSegment]={"Glas"}>} $(vNettoFörs)) >= $(vOmsGMonth) ,1,0),

ChartDimensionHere))

Wed, 23 Nov 2016 10:48:24 GMT

Thanks for your helpfullness and pation.

Håkan