Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

maxsheva
Contributor

Calculation by each date

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.

4 Replies
maxsheva
Contributor

Re: Calculation by each date

Would be grateful for any help.

Re: Calculation by each date

Max - Could you explain the logic to us? 

maxsheva
Contributor

Re: Calculation by each date

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
Contributor III

Re: Calculation by each date

Hi,

This my example.

Community Browser