topic Re: Inter field calculations in QlikView

Inter field calculations

Thu, 02 May 2013 04:39:39 GMT

Hello

i want to do inter field dividation . field1/field2 at sript level how could i do it ,pls give me suggestions

sushil353 — Thu, 02 May 2013 04:53:06 GMT

it is simple:

tab1:

LOAD * INLINE [

field1,field2

1, 1

2, 3

3, 5

4, 7

]

;

tab2:

load *

,field1/field2 as field3

Resident tab1;

HTH

Sushil

Thu, 02 May 2013 05:45:43 GMT

thank u shushil,

I have done same in if condition but it did not shows result

if(cond=true,field1/field2) as sales But it shows field1 in sales.

sushil353 — Thu, 02 May 2013 05:54:48 GMT

Hi,

Below script is working for me

tab1:

Load * inline

[

field1,field2,cond

1, 2,T

2, 4,f

3, 9,T

];

tab2:

LOAD

if(cond='T',field1/field2) as test

Resident tab1;