how to subtract 2 values from inline table

[#1]

Hi,

i have this inline table

load * inline [

Calc,Items

'A','GHY'

'B','JKU'

'C','EYT'

];

I want now to make another inline table with this structure

Gross,Calc

'mm' , 'A' - 'B'

'OO' , 'C' - 'B'

How to do that?

Thanks,

Mona

[its_anandrjs]

Hi,

Any reason to do this type of calculation because after table load you can do this type of calculation.

Regards,

Anand

[#3]

i want to have one field which is Gross and inside it these values 'mm','oo',..........

[whiteline]

Hi.

What do you mean by the statement 'A' - 'B' ?

[Anonymous]

hi whilteline,

                       I guess mona_qlik means subtracting value of A with Value of B.... if A=5, B=2 den mm=3

                       Anybdy knwz? even m interested to know......

regards,

Vaibhav

[Anonymous]

I think calculation is not evaluatted inside inline load statements.

So I will do the subsctration in two ways :

1) The subsctration is done outside of the inline load statements.

A = 5;
B = 2;
C = A-B;

load * inline [
Gross,Calc
'mm' ,  '$(C)'
'OO' ,  '$(A)-$(B)'
];

2) Perform a resident load and do the subsctration in that load statements.

I hope this helps!

MultiView