Result of expression between range

Fri, 10 Aug 2012 13:59:59 GMT

I have a problem with the result of an expression which does not understand, to put it in context of the situation, I have an asociative model for which there is a large fact table and some dimensions. There is also a draw isolated model in which there is a range qualification.

My problem is in a pivot table for which the result of an expression must be qualified according to the table of ranks. The rating makes this expression works well only for some ranges.

This is the expression to evaluate

Sum({<Base={1}>} [Valor ventas])

Sum({<Base={1}>} [Valor presupuesto ciclico])

And this is the expression to Qualify in ranges

aggr(if( $(vCumplimientoPpto.)<=[Escalas compensacion mayoristas.Rango Max]

and $(vCumplimientoPpto.)>=[Escalas compensacion mayoristas.Rango Min] ,

[Escalas compensacion mayoristas.Valor escala]

[Escalas compensacion mayoristas.Valor escala],[Negocio compensacion])

Where $(vCumplimientoPpto.) solve the formula that is contained in variable vCumplimientoPpto.

Sum({<Base={1}>} [Valor ventas])

Sum({<Base={1}>} [Valor presupuesto ciclico])

in the variable the formula are without "=" at begin

Check the Pivot table result and Range Qualification Table

Pivot Table

Table of Qualification Ranges

topic Result of expression between range in QlikView

Result of expression between range