topic Re: Calculation by each date in QlikView

Calculation by each date

maxsheva — Wed, 19 Apr 2017 22:26:40 GMT

Hi,

Table1:

LOAD * INLINE [

Group, Date, Value1

Group1, 01/01/2017, 100

Group1, 01/04/2017, 0

Group1, 01/05/2017, 0

Group1, 01/07/2017, 30

Group1, 01/10/2017, 0

];

I need create calculation by each date something like this

=Previous(Value1)+Value1-Previous(Value1)/(Days-1)

As result

Group, Date, Value1

Group1, 01/01/2017, 90

Group1, 01/02/2017, 80

Group1, 01/01/2017, 70

Group1, 01/04/2017, 60

Group1, 01/05/2017, 50

Group1, 01/06/2017, 70

Group1, 01/07/2017, 52.5

Group1, 01/08/2017, 35

Group1, 01/09/2017, 17.5

Group1, 01/10/2017, 0

Thx.

maxsheva — Thu, 20 Apr 2017 07:25:18 GMT

Would be grateful for any help.

tamilarasu — Thu, 20 Apr 2017 09:39:51 GMT

Max - Could you explain the logic to us?

maxsheva — Thu, 20 Apr 2017 12:33:21 GMT

I need some burndown process there.

Each date has to show value which is less then previous by some calculated formula.
For example we have value 100 on 01/01/2017

Period is 01/01/2017 till 01/10/2017
So total are 10 days.

I need this

1st day = 100-100/10 = ValueDay1

2nd day = ValueDay1- ValueDay1/(10-1) = ValueDay2

3nd day = ValueDay2-ValueDay2/(9-1) = ValueDay3

and the same till the end of period

lcloatre — Fri, 21 Apr 2017 13:15:00 GMT

Hi,

This my example.