growth rates in Qlik Sense

[jleefjcapital]

Hello,

I would like to create a new variable in Qlik Sense for growth rates.   As an example of what I'm looking for: 

[Alabama Jobs] is the main field that I'm pulling from an external database-- I would like to compute the period over period growth rate as in column three.   There there a way to hard code this in the data editor ?   

Date	Alabama Jobs	Period over period growth rate
10.2015	159
11.2015	200	26%
12.2015	130	-35%
1.2016	250	92%
2.2016	140	-44%
3.2016	110	-21%
4.2016	100	-9%
5.2016	100	0%
6.2016	100	0%
7.2016	180	80%
8.2016	340	89%
9.2016	249	-27%
10.2016	200	-20%
11.2016	242	21%

[Gysbert_Wassenaar]

Once you've done the homework I gave you and understand the basic idea behind those concepts have a look at the attached qlik sense app. On the second sheet you'll find a pivot table object that uses the above() function and a table object that makes use of the As-Of table and the set analysis expressions. In the Data load editor you can find the piece of script code that creates the As-Of table.

[jleefjcapital]

Thanks, Gysbert. 

I will start with creating a measure for the latest month---

I created this measure, but it's coming up null. 

Sum({$<MonthYear={"Sep2016"}>}BLS_jobs_state) / Sum({$<MonthYear={"Sep2015"}>}BLS_jobs_state)-1

[jleefjcapital]

Which date would this newly created measure be associated with?  Is it the latest date,  Sep2016? 

[Gysbert_Wassenaar]

There are a number of possible reasons your measure doesn't return a result. Can you post a small qlik sense app that shows the problem? That way I won't have to guess.

[jleefjcapital]

I'm not able to attach the file. 

[Gysbert_Wassenaar]

Why not? Do you not know how or for other reasons?

If it's because you don't know how then that's easily solved.

Reply to the discussion from the discussion itself, not from your inbox. After clicking the Reply link a dialog will open where you can enter a text. At the top right you can find the Use advanced editor link. Click on that link to open the advanced editor. At the bottom right you'll find a paperclip icon with a link named Attach next to it. Click on that link to open a dialog that allows you to upload files.

[jleefjcapital]

There is no advanced editor link --- Am I looking in the right place?

[Gysbert_Wassenaar]

Like I said:

Reply to the discussion from the discussion itself, not from your inbox

[jleefjcapital · Accepted solution]

I see.  I've attached the QVF ----the measure is already created titled State jobs_yy% change.

a. (Sum({$<MonthYear={'Sep2016'}>}BLS_jobs_state) / Sum({$<MonthYear={'Sep2015'}>}BLS_jobs_state))-1

Thanks.

[Gysbert_Wassenaar]

Ah, sorry, I'm not going to download 80MB just to have a look. Can you reduce the data so the app still demonstrates the problem, but is about 50 times smaller?