topic Re: how to subtract 2 values from inline table in QlikView

how to subtract 2 values from inline table

Sun, 11 Nov 2012 12:57:21 GMT

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 — Sun, 11 Nov 2012 13:00:30 GMT

Hi,

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

Regards,

Anand

Sun, 11 Nov 2012 13:05:46 GMT

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

whiteline — Sun, 11 Nov 2012 19:46:21 GMT

Hi.

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

Anonymous — Mon, 12 Nov 2012 10:00:10 GMT

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 — Mon, 12 Nov 2012 11:32:54 GMT

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