topic Re: aggregation in QlikView

aggregation

Fri, 03 Aug 2012 07:54:06 GMT

I need to show a list with years and values but only the years with diferents values. I can do it with a SQL but it's not the idea. The example is

año ,instalacion,potencia

2009 , 500, ,1000

2010 , 500, ,1000

2011 , 500 ,1000

2012 , 500 ,3000

2009 , 100 ,1000

2010 , 100 ,1000

2011 , 100 ,2000

2012 , 100 ,3000

the result will be:

2009 , 500, ,1000

2012 , 500 ,3000

2009 , 100 ,1000

2011 , 100 ,2000

2012 , 100 ,3000

Not the records with de same potencia, and min(año)

MayilVahanan — Fri, 03 Aug 2012 15:05:49 GMT

Try like this,

Load * Inline

[

año,instalacion,potencia

2009,500,1000

2010,500,1000

2011,500,1000

2012,500,3000

2009,100,1000

2010,100,1000

2011,100,2000

2012,100,3000

] Where potencia <> Previous(potencia);

Hope it helps

Fri, 03 Aug 2012 22:21:52 GMT

Thanks, It's works but I need do the same in a table with the condition numinst=previous(numinst)

I try using sum with set analisys.