Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
ecabanas
Creator II
Creator II

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
jagan
Luminary Alumni
Luminary Alumni

Hi,

PFA file for solution.

Regards,

Jagan.

View solution in original post

6 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

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

Regards,

Jagan.

ecabanas
Creator II
Creator II
Author

Sorry Jagan I cannot understand to you!

jagan
Luminary Alumni
Luminary Alumni

Hi,

Add this as new expression in your straight table.

Regards,

Jagan.

ecabanas
Creator II
Creator II
Author

it does not work, look the result:

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

pic.jpg

jagan
Luminary Alumni
Luminary Alumni

Hi,

PFA file for solution.

Regards,

Jagan.

View solution in original post

ecabanas
Creator II
Creator II
Author

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