Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

ecabanas
Contributor

Calculation prior month

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

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

And this table

pic.jpg

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

How could I do?

Thanks

Eduard

1 Solution

Accepted Solutions
MVP
MVP

Re: Calculation prior month

Hi,

PFA file for solution.

Regards,

Jagan.

6 Replies
MVP
MVP

Re: Calculation prior month

Hi,

Try like this

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

Regards,

Jagan.

ecabanas
Contributor

Re: Calculation prior month

Sorry Jagan I cannot understand to you!

MVP
MVP

Re: Calculation prior month

Hi,

Add this as new expression in your straight table.

Regards,

Jagan.

ecabanas
Contributor

Re: Calculation prior month

it does not work, look the result:

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

pic.jpg

MVP
MVP

Re: Calculation prior month

Hi,

PFA file for solution.

Regards,

Jagan.

ecabanas
Contributor

Re: Calculation prior month

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

Community Browser