topic Re: Row Subtraction in Table in QlikView

Row Subtraction in Table

Thu, 18 Jun 2015 12:11:01 GMT

Hi friends,

I have this table

The field highlighted in bold , Row E i want the value Row F - Row E, so the total comes correct in Total 1.

Can you please tell me how to deal with row subtraction?

Regards,

fvelascog72 — Thu, 18 Jun 2015 12:46:19 GMT

Hi,

I hope I understand your requeriments.

See attached file.

Thu, 18 Jun 2015 13:10:21 GMT

Hi Federico,

Thanks for your quick response.

But the values highlighted in bold, Row E is still showing 6.8 and i want Row F - Row E (6.8-3.9 = 2.9) for batting

For bowling (7.6-3.8 = 3.8) and everything on the table remains same.

Regards,

Thu, 18 Jun 2015 13:32:07 GMT

Hi,

I am not sure whether column subtraction like col(3)-col(2) works in case of rows as well.

Regards,

sunny_talwar — Thu, 18 Jun 2015 13:40:29 GMT

Try these expressions:

Batting: =Sum(Batting) - If(Type = 'E', sum(TOTAL {<Type = {'F'}>}Batting), 0)

Bowling: =Sum(Bowling) - If(Type = 'E', sum(TOTAL {<Type = {'F'}>} Bowling), 0)

Output:

I used the sample that was prepared by fvelascog72 and made slight changes to it

Best,

Sunny

Thu, 18 Jun 2015 15:22:40 GMT

Hey Thanks Sunindia,

This is perfect!

Regards,

sunny_talwar — Thu, 18 Jun 2015 15:23:38 GMT

No problem

I am glad I was able to help.

Best,

Sunny