topic Set analysis in QlikView

Set analysis

Mon, 02 Aug 2010 19:05:57 GMT

Hello I am trying to get the last value (%Realizado) of an indicator without selecting anything, I have these set analysis:

=avg( {<Indicador= {'Gastos Totales vs Presupuesto'} >} %Realizado), with this one I have the average score for all dates, but I want ti get only the last one, how can I this whitout selecting a date or an "Indicator"?

Thank you!

Set analysis

Mon, 02 Aug 2010 20:07:25 GMT

Normal 0 21 false false false FR X-NONE X-NONE

try something like this :

=avg( {< Date={'$(=max({1}Date))'} , Indicador= {'Gastos Totales vs Presupuesto'} >} %Realizado)

Normal 0 21 false false false FR X-NONE X-NONE

{1} means independant of the selection

What means %Realizado ? Be careful if it's a percentage, because you maybe calculate a mean of percentage.

JJJ

Set analysis

Mon, 02 Aug 2010 21:04:11 GMT

Hello, thank you for your quick response, I did this

=avg( {<Semana={"$(=max({1}Semana))"} , Indicador= {'Gastos Totales vs Presupuesto'} >} %Realizado)

But is not working....