How can i calculate growth rate?

[#1]

Hi everyone,

I have time series data, saved as variable X(t), As you know it varies by time. So I want to calculate the growth rate for X(t) month by month! But it does not work in Qlikview!!

And the my time format is not compatible with Qlik time format!!

The growth rate=(X(t)-X(t-1))/X(t-1)

I would appreciate it if some one could give me some pieces of advice.

Thank you in advance

[sunny_talwar]

Try this expression and see if this helps (in a gauge chart):

=Num(Sum({<Time = {"$(=MaxString(Time))"}>}Value)/Only({<Time = {"$(=MaxString(Time))"}>}Aggr(Above(Sum({<Time = , Year = , Month = >}Value), 12, 0), Time))-1, '#,##0.00%')

Attaching the sample qvw document for your convenience.

HTH

Best,

Sunny

[#3]

Dear Sunny,

thank you for your reply, I tried your formula but it did not work when I filter the time! for example, when I selected a month it showed no data to show!

Thank you in advance,

Zahra

[sunny_talwar]

That is because there is only one period available in the data where it's 12 month back is available, i.e. only 93/01 has 92/01 available in the sample data. But if there were 91/12 available, you would have seen a result when you selected 92/12.

Does that make sense?

[#5]

Oops! Sorry!

Data that I use consist of more periods, I made mistake in writing the formula!

sorry again and thank you very much.

And I can not choose the correct answer this time because its not active!

best

Zahra

[sunny_talwar]

Hahahaha yup because this thread already have a correct answer. You don't have to do this, but you can always rewards by selecting helpful answers (You can have only one Correct Answer, but Multiple Helpful Answers)

Best,

Sunny

[#7]

Ok! Thank you.

Best

Zahra