topic Re: How to Subtract second value of column A from first value of column B. in QlikView

How to Subtract second value of column A from first value of column B.

Wed, 27 Jul 2011 11:35:11 GMT

I have two columns with 5 rows,

A{1,2,3,4,5} And B{6,7,8,9,10}

I want to subtract 2nd value from column A from 1st value of column B.

(i.e. I want to subtract (n+1)th value from column A from (n)th value of column B.)

So there will be one column with 4 rows, in this case, (6-2 = 4), (7-3 = 4), (8-4 = 4), (9-5 = 4)

(n-1 values in general)

What is the script for this expression?

Can we use an in built function Previous? if yes, how?

Thanks,

Himanshu

SunilChauhan — Wed, 27 Jul 2011 11:52:49 GMT

Min(B)- min(A,2)

top (B)_top(A,2)

try out this

perumal_41 — Wed, 27 Jul 2011 11:59:20 GMT

above(a,1)-b use this expression

jagan — Wed, 27 Jun 2012 08:10:06 GMT

Hi,

Try this script,

TableName:

LOAD

PreviousB - A AS NewColumn,

A, B

WHERE Previous(B) <> NULL();

LOAD

Previous(B) AS PreviousB,

LOAD * INLINE [

A, B

1, 6

2, 7

3, 8

4, 9

5, 10

];

Hope this helps you.

Regards,

Jagan.