topic Re: above function? in QlikView

above function?

Wed, 25 Jun 2014 07:21:33 GMT

above(sum(Sales), 2)+above(sum(Sales), 1) how to calculate this above(sum(Sales), 2)

PLS HELP ME

sales:

800

1200

1000

Re: above function?

MK_QSL — Wed, 25 Jun 2014 08:14:01 GMT

What is your requirements?

Re: above function?

hic — Wed, 25 Jun 2014 08:27:25 GMT

You should not use '+' together with the inter-record functions since these return NULL sometimes, and '+' doesn't work with NULL.

Instead, you should use RangeSum():

RangeSum(above(sum(Sales), 2), above(sum(Sales), 1))

But just as Manish Kachhia, I wonder what you really are trying to do...

HIC

Re: above function?

Wed, 25 Jun 2014 08:34:25 GMT

Hi henric

how it is calculating here for this expression above(sum(Sales), 2

above(sum(Sales), 2=? what is output and how pls tell me

i am thankful to u

Re: above function?

jagan — Wed, 25 Jun 2014 08:42:34 GMT

Hi Manoj,

Suppose you have a straight table like below then

S.No. Sum(Sales) Above(Sum(Sales), 2)

1 5 -

2 10 -

3 20 5

4 25 10

5 30 20

Here Above() will give the Previous row expression values, if you do not give second parameter (2) then it returns the above row value, if you specify 2 then it will return second above row.

Hope this helps you.

Regards,

Jagan.

Re: above function?

jagan — Wed, 25 Jun 2014 08:43:39 GMT

Hi,

Continuation to my previous post

For the first two rows you don't have second previous rows that is why you are getting Null values.

Regards,

Jagan.

Re: above function?

Wed, 25 Jun 2014 09:04:18 GMT

Thank u very much yar

like wise if u take below then it will give current line below rows right

Re: above function?

jagan — Wed, 25 Jun 2014 09:06:06 GMT

Yes.

Regards,

jagan.

Re: above function?

SunilChauhan — Wed, 25 Jun 2014 09:10:08 GMT

above(above(sum(Sales)))+above(sum(Sales))