topic Re: using above on an expression in QlikView

using above on an expression

samuel_brierley — Sun, 11 Oct 2015 11:01:29 GMT

Hi all,

is it possible in an expression to use above on its self? so for example my calculated field may be;

above(myfself,1)- 100

i would use an ifnull put 1000 to account for the first field being null so it would go

Calculated field

1000

900

800

and so on

thats a very simplistic example but hopefully is enough to trigger some good ideas.

Re: using above on an expression

lironbaram — Sun, 11 Oct 2015 11:27:00 GMT

if you look to create a floating dimension with no connection to the data

you can use valueloop function

=ValueLoop(1000,0,-100)

Re: using above on an expression

petter — Sun, 11 Oct 2015 11:30:53 GMT

You cannot directly reference the same column but you can achieve what you want by using an intermediate/helper column. If you need you can hide this helper column because it is not normally useful except for this particular function.

Re: using above on an expression

samuel_brierley — Sun, 11 Oct 2015 11:38:31 GMT

i think the help column may be the way to go however im confusing myself as to how i would set that up.

ill make an attempt to explain;

a	b	C
10	5	1000
20	10	900
30	10	1000
40	5	1100

what i want my formula to do is starting at 1000 if column a is less than 21 AND column b is greater than 5 then minus 100, if not add 100.

C represents what the result would be

Re: using above on an expression

petter — Sun, 11 Oct 2015 12:02:41 GMT

Actually you CAN directly reference the same column - but using helper columns can help you break down the challenge of creating a solution into a more stepwise approach making it easier to solve.

Look at what I have attached it is close to what you want - but I didn't quite understand all of your explanation of logic. Have a loook at it and see if you can make it work for you:

Re: using above on an expression

samuel_brierley — Sun, 11 Oct 2015 12:10:48 GMT

Brilliant thank you!!

Re: using above on an expression

petter — Sun, 11 Oct 2015 19:55:47 GMT

My pleasure - please mark the question as answered so the thread can be closed