Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
1 Solution

Accepted Solutions
jagan
Partner - Champion III
Partner - Champion III

Hi,

PFA file for solution.

Regards,

Jagan.

View solution in original post

6 Replies
jagan
Partner - Champion III
Partner - Champion III

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
Partner - Champion III
Partner - Champion III

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
Partner - Champion III
Partner - Champion III

Hi,

PFA file for solution.

Regards,

Jagan.

ecabanas
Creator II
Creator II
Author

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