topic Re: Addition of two field values in QlikView

Addition of two field values

bharatkishore — Mon, 30 Oct 2017 13:17:54 GMT

Hi All,

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

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

Re: Addition of two field values

sunny_talwar — Mon, 30 Oct 2017 13:27:57 GMT

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?

Re: Addition of two field values

bharatkishore — Mon, 30 Oct 2017 13:33:07 GMT

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

Re: Addition of two field values

sunny_talwar — Mon, 30 Oct 2017 13:36:06 GMT

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?

Re: Addition of two field values

bharatkishore — Mon, 30 Oct 2017 13:44:53 GMT

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

Re: Addition of two field values

sunny_talwar — Mon, 30 Oct 2017 13:53:24 GMT

So, basically you want this

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

Check attached

Re: Addition of two field values

bharatkishore — Mon, 30 Oct 2017 13:58:20 GMT

Hi Sunny,

Slight correction in your formula i.e.

4559 - 379.92 +468.83 - 22.84 + 0 = 4625.07

Re: Addition of two field values

sunny_talwar — Mon, 30 Oct 2017 14:02:23 GMT

Check now