Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Addition of two field values

Hi All,

I have a chart. In that i have a dimension called cat and some expressions. Below image for reference:

T.PNG

In the IB end the value for 0 to 1 year is correct.

But from the second one i.e. b)1 to 2 year i need to calculate 4559+379.92+468.83-22.84+0.. I want to how can we sum 379.92+468.83.


The same for C)2 to 3 year i need to calculate 3874+322.83+379.92.83-22.07+0.


The same for D)3 to 4 year i need to calculate 3489+290.75+322.83-22.07+0.


Can you please tell me how can we do this.


Attached app for reference.


Please let me know if you require anything more.


Thanks,

Bharat

1 Solution

Accepted Solutions

7 Replies

So the calculation for 0 to 1 is completely difference from  rest of them? Or is the only difference is that except 0 to 1, you want to look at Aging for that period and the previous period?

Creator III
Creator III

Hi Sunny,

yes,the only difference is that except 0 to 1, I want to look at Aging for that period and the previous period..


The calculation for 0 to 1 is fine... rest i need in the above one i explained.. The value for IB End for 0 to 1 is correct..Rest i i need to sum of this aging and previous aging..

Please let me know if you need anything more.

Thanks,

Bharat

Going by the same logic for 1 to 2 years.... 0 to 1 would be something like this, right

5,626 + 468.83 - 24.71 + 175.56 = 6,245.68... how is 5,507.71 correct? Am I missing something here?

Creator III
Creator III

hi Sunny,

For 0 to 1 it is      5626- 468.83-24.71+ sum(total of cons)..i.e.199.69+175.56

But for rest it is the formula changes to 4559-379.92+468.83-22.84+0


Please let me know if you need anything more

So, basically you want this

4559 - 379.92 - 468.83 - 22.84 + 0 = 3,687.41?

Check attached

Creator III
Creator III

Hi Sunny,

Slight correction in your formula i.e.

4559 - 379.92 +468.83 - 22.84 + 0 = 4625.07