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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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!!!