Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Result of expression between range

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

Pivot.png

Table of Qualification Ranges

TableRanges.png

0 Replies