Discussion Board for collaboration related to QlikView App Development.
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
Are you trying to do this on the front end or the script? if in the script you will need to use the Peek or Previous function and if you are trying to do in front end, you can achieve the same by using RangeSum(Above() or Below()) function. For more help on this topic, you will have to share more information.
I hope it will help u to complete the task
LOAD * Inline [
((salary-Previous(salary))/Previous(salary))*100 as %growth
Thank you for replying.
Yes, I used the rowno () (as date format dos not match the Qlik date format), above() and below() functions in front end. do the peek and previous work when I use the rowno () function?
And I wonder if you can let me know what is the difference between sum and rangesum.
Dear balaji k,
Thank you very much but it works when data is sorted or there is some kind of ranking. Am I true?
In another word, can I use the rowno() function in script?
Dear Avinash R,
Thank you, Yes of course.
as usual numbers 1-12 are the months and 93 , 92 are the years but the problem is that the months do not matches the Qlikview Date and calender.
Is this what you are trying to get?
LOAD RowNo() as Sort,
LOAD * Inline [
Created a straight table with Time as dimension and three expressions: