Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
New Contributor

Calculate evolution from one month to another

Hello everyone   I have a database with the number of total sales for each month, for year 2018. How can I calculate the evolution from one month to another in percentage (example: from May to June is a growth with 3.2%). Thank you very much!

Tags (1)
1 Reply

Re: Calculate evolution from one month to another

What kind of chart are you using? Is it a pivot table or straight table? Are you using MonthYear or Month as one of your dimension? If you are... you need to use Inter-Record Functions such as Above/Below for Straight table or After/Before for pivot table where Month or MonthYear is a pivoted dimension. You can also use The As-Of Table which need some script modifications.

If Month or MonthYear is not a dimension, then you can use set analysis to do this