topic Re: SUM Indicator1 when Dim1=ValueX and Dim2=ValueY in QlikView

SUM Indicator1 when Dim1=ValueX and Dim2=ValueY

Tue, 23 Oct 2012 21:38:22 GMT

Hello

How can I a set up an expression to SUM Indicator1 when Dimension 1 has a certain value and a Dimension 2 another particular value

johnw — Tue, 23 Oct 2012 21:47:15 GMT

sum({<Dimension1={'Some Value'},Dimension2={'Another Value'}>} Indicator1)

Tue, 23 Oct 2012 21:52:49 GMT

Hi Armas

You could use set analysis in an expression such as

=Sum({$<Dim1={ValueX},Dim2={ValueY}>}Indicator1)

This will sum the values of Indicator1 only where DIM1=ValueX and DIM2=ValueY.

E.G.

Sum({$<Dim1={30},Dim2={50}>}Indicator1)

gives the answer 145 i.e. 100 + 45, the two values of indicator1 where Dim1=30 and Dim2=50.

Hope that helps

Steve