topic Re: Improve Performance in QlikView

Improve Performance

Tue, 14 Feb 2012 16:47:20 GMT

Hi everybody, I have e Performance Issue, it takes to much to calculate between sellections I make, Is there a better way to expres this?

(RowNo()>1,

(RangeSum(Above(SUM({$<AGRUPADOR={'01_VENTAS'}>}(DATA_AVER))/SUM({$<AGRUPADOR={'01_VENTAS'}>}total DATA_AVER) , 0, NoOfRows()))>=.95,'C',

(RangeSum(Above(SUM({$<AGRUPADOR={'01_VENTAS'}>}(DATA_AVER))/SUM({$<AGRUPADOR={'01_VENTAS'}>}total DATA_AVER) , 0, NoOfRows()))>=0.80,'B',

(RangeSum(Above(SUM({$<AGRUPADOR={'01_VENTAS'}>}(DATA_AVER))/SUM({$<AGRUPADOR={'01_VENTAS'}>}total DATA_AVER) , 0, NoOfRows()))>=.50,'A',

(RangeSum(Above(SUM({$<AGRUPADOR={'01_VENTAS'}>}(DATA_AVER))/SUM({$<AGRUPADOR={'01_VENTAS'}>}total DATA_AVER) , 0, NoOfRows()))<=0.50,'AA'))))

,'AA')

Thank you All!!

Tue, 14 Feb 2012 16:49:44 GMT

Hola Javier,

Podrías subir un QVW de ejemplo?

Tue, 14 Feb 2012 17:03:23 GMT

Si, Claro, Aquí está.

Gracias!!

jagan — Wed, 15 Feb 2012 05:50:07 GMT

Hi,

Create the following expressions

Expression 1:

RangeSum(Above(SUM({$<AGRUPADOR={'01_VENTAS'}>}(DATA_AVER))/SUM({$<AGRUPADOR={'01_VENTAS'}>}total DATA_AVER) , 0, NoOfRows()))

Now use this expression in another expression like this

if(RowNo()>1,

if([Expression 1 Name]>=.95,'C',

([Expression 1 Name]>=0.80,'B',

(

[Expression 1 Name]>=.50,'A',

(

[Expression 1 Name] <=0.50,'AA')))),'AA')

Here we are instead of calculating the expression many times we are reusing the expression 1 in expression 2.

If you are using straight table then hide the first expression column in Presentation tab.

Regards,

Jagan.

Wed, 15 Feb 2012 16:18:40 GMT

Thank you Jagan but, It takes more time than the original expression. 😕

Wed, 15 Feb 2012 19:37:00 GMT

Hola Javier,

Ya le estuve echando un ojo y esta difícil optimizarlo para el acumulado y

comparación que haces. Lo único que se me ocurre es que acumules en el

script.

Sent from my iPad

On Feb 15, 2012, at 10:18 AM, javierortiz <