topic Re: Calculation prior month in QlikView

Calculation prior month

ecabanas — Tue, 23 Apr 2013 11:28:39 GMT

Hi I have a set analisys with the following set analysis:

SUM({<EVE_FAMILIA={'110'},CalendarMonthName=,FAMILIA=>} IMPORTBRUT)*-1

And this table

I want to do another column doing the calculation feb2013(february)/ene2013(january)

How could I do?

Thanks

Eduard

jagan — Tue, 23 Apr 2013 11:43:52 GMT

Hi,

Try like this

= Sum(DimensionName)/Alt(Above([At Cliente]), 0)

Regards,

Jagan.

ecabanas — Tue, 23 Apr 2013 11:53:35 GMT

Sorry Jagan I cannot understand to you!

jagan — Tue, 23 Apr 2013 11:55:48 GMT

Hi,

Add this as new expression in your straight table.

Regards,

Jagan.

ecabanas — Tue, 23 Apr 2013 12:01:51 GMT

it does not work, look the result:

= Sum(CalendarMonthAndYear)/Alt(Above([At Cliente]), 0)

jagan — Tue, 23 Apr 2013 12:35:27 GMT

Hi,

PFA file for solution.

Regards,

Jagan.

ecabanas — Tue, 23 Apr 2013 12:54:49 GMT

GREATTTTT!!!! thank's Jagan!!!