Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bharatkishore
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
sunny_talwar

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?

bharatkishore
Creator III
Creator III
Author

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

sunny_talwar

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?

bharatkishore
Creator III
Creator III
Author

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

sunny_talwar

So, basically you want this

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

Check attached

bharatkishore
Creator III
Creator III
Author

Hi Sunny,

Slight correction in your formula i.e.

4559 - 379.92 +468.83 - 22.84 + 0 = 4625.07

sunny_talwar

Check now

Capture.PNG