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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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