topic Re: Obtain Last Year (Object) in QlikView

Obtain Last Year (Object)

pgalvezt — Wed, 25 Jan 2017 17:05:59 GMT

Hello,

I´m Trying to obtain last year with my formula but it is not working,

Actual Year is 3.689 I need to obtain 2.264, Instead 1.907.

I put an example for better comprehenssion,

Thanks!

Re: Obtain Last Year (Object)

sunny_talwar — Wed, 25 Jan 2017 17:12:58 GMT

May be this:

= Num((Num(Sum({< Año = {$(xAñoAnt)}>}Aggr(

Num(Num(Sum({< Año = {$(xAñoAnt)}>}ValorOpeMonedaCorregidoUpdate_Consumo/Divisor),'#.##0')*(UFmax)/Sum({< Año = {$(xAñoAnt)}>}CantidadNeta_Consumo),'#.##0') ,CodFamiliaProducto_Consumo,DescrFamiliaProducto_Consumo)),'#.##0')) /

Count({< Año = {$(xAñoAnt)}>}Distinct(CodFamiliaProducto_Consumo)) ,'#.##0')

Re: Obtain Last Year (Object)

pgalvezt — Wed, 25 Jan 2017 17:19:24 GMT

Perfect Thank you Sunny!