Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Month Variation

Hello,

I´m trying to create an expression that calculate the month variation of two numbers, like January=102 vs. February =104, so the variation is 104/102=1.96%, anyone can help me.

Thanks

PD: sorry my English

Roberto

1 Reply
Not applicable
Author

Hi

Not sure to understand your issue  but I think you should use ABOVE function.

Create an expression :   Sum( Datos) / Above(Sum(Datos))

With a dimension :   Year & Month

JJ