Table values reduction by date

[#1]

Hi Guys,

I created a straight table in qlikview as follows:

Name               StartDate          ContractPeriod        Total Guarantee        Total Savings        Balance savings 

                                                                                                              € 1,325.40              € 4,807.88

Automan          1/2/2015             24                            6,133.28                   € 0,00                    € 6,133.28

Automan          1/3/2015             23                            6,133.28                   € 349,85                 € 5,783.43

Automan          1/4/2015             22                            6,133.28                   € 341,85                 € 5,791.43

Automan          1/5/2015             21                            6,133.28                   € 321,85                 € 5,811.43

Automan          1/6/2015             20                            6,133.28                   € 311,85                 € 5,821.43

Automan          1/7/2015             19                            6,133.28                   € 0,00                     € 5,821.43

I got the Total Savings as follows:

Sum(Total Savings)

The Balance Savings as follows:

Sum([Total Guarantee] - [Total Savings])

The totals on the first row came out as expected. But my question is, I will like the Balance savings to be subtracted from Total Savings instead of the Total Guarantee.

Looking at the table, Balance savings shows € 4,807.88 but on the 1/7/2015, I am still having a Balance savings of € 5,821.43.

Please any help on how to fix that as the dates increase will be truly appreciated.

Thanks,

Simon

[sunny_talwar]

May be something like this:

If(RowNo() = 1, Sum([Total Guarantee] - [Total Savings]), Balance - [Total Savings])

Here Balance will be the the expression label for this expression

[#3]

Hi Sunny,

I tried it and it did not work. Please any further ideas on how to work this out?

Thanks,Simon.