topic Re: Percentage change between days in QlikView

Percentage change between days

stjernvd — Tue, 16 Jun 2015 17:11:24 GMT

Hi All,

I would like to calculate the percentage change in the script between stock value on different days.

Here is my original data:

What would be a good expression for doing this? I tried this expression but it doesn't work:

FirstSortedValue(Day,Stock Value) - Above(FirstSortedValue(Day,Stock Value) / Above(FirstSortedValue(Day,Stock Value)

Does this make sense?

maxgro — Tue, 16 Jun 2015 17:20:46 GMT

in script or in chart?

if in chart what's the expression for 2nd column (stock value)?

stjernvd — Tue, 16 Jun 2015 17:25:21 GMT

Stock Value is just a number...no expression for it...same with day...the data above is from my excel file...

I want to edit it in the script if possible..to load the percentage change of stock value from day to day as 'growth rate'....

maxgro — Tue, 16 Jun 2015 17:32:33 GMT

like this?

source: // replace with your data

load

date(makedate(2015) + rowno() -1) as Day,

floor(rand()*10) as Value

AutoGenerate

365;

final:

load

Day,

Value,

Peek(Value) as PrevValue,

(Value - Peek(Value)) / Peek(Value) as Change%

Resident source

order by Day;

stjernvd — Tue, 16 Jun 2015 17:41:00 GMT

Yes thank you very much!

maxgro — Tue, 16 Jun 2015 17:43:55 GMT

I think you can do that in chart too; if sum(val) is expression, and the chart is day ordered, above(sum(val))