Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-07-17 03:21 AM

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!

448 Views
0 Likes
1 Reply
sunny_talwar
MVP
MVP
‎2018-07-17 11:47 AM

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

393 Views
0 Likes