topic Re: Expression help in QlikView

Expression help

danielnevitt — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a table with the following expressions:

Position: Sum(pos_qty)/1000

Open Interest: sum(OPEN_INTEREST)

%: fabs(column(1)/column(2))

Is it possible to only show the results where the % calculation result is greater than 5%?

Regards,

Daniel

ecolomer — Mon, 08 Aug 2016 15:02:14 GMT

Yes you can use a if expression in order to check the result and put result in colour = with() for nothing see

danielnevitt — Mon, 08 Aug 2016 16:08:53 GMT

Hi Enrique,

Thank you for your response.

Sorry I am unsure how to create the if expression. Would you mind sending me some example code?

Thanks,

Daniel

sunny_talwar — Mon, 08 Aug 2016 16:17:36 GMT

May be like this

Position:

If(fabs(Sum(pos_qty)/1000/Sum(OPEN_INTEREST)) > 0.05, Sum(pos_qty)/1000)

Open Interest:

If(fabs(Sum(pos_qty)/1000/Sum(OPEN_INTEREST)) > 0.05, Sum(OPEN_INTEREST))

If(fabs(Sum(pos_qty)/1000/Sum(OPEN_INTEREST)) > 0.05, fabs(Sum(pos_qty)/1000/Sum(OPEN_INTEREST)))

ecolomer — Mon, 08 Aug 2016 16:17:56 GMT

First possibility:

if(ffabs(column(1)/column(2)) > 0.05, fabs(column(1)/column(2)),' ')

then if the value is > 0,05 (5%) you write a blanc

Second:

you write your expression normaly and in the expression open + option and wirte in Text Color:

if(fabs(column(1)/column(2))< 0,05, white())

for put text color in white and not see them