topic Re: need help to write the expression in QlikView

need help to write the expression

suvechha_b — Wed, 07 Oct 2015 14:22:07 GMT

How can I plot this in qlikview expression:

Potential Sale Value = Outstanding Order if the net stock > Outstanding Order else Potential Sale Value = net stock if net stock < Outstanding Order

if Netstock is Null put null else

Potential Sale Value = Outstanding Order if the net stock > Outstanding Order else Potential Sale Value = net stock if net stock < Outstanding Order

swuehl — Wed, 07 Oct 2015 14:34:55 GMT

maybe something like

=RangeMin( Sum([Outstanding Order]), Sum([Net Stock]) )

raghvendrasingh — Wed, 07 Oct 2015 14:52:03 GMT

Hi,

As per my understanding:-

Please try this one

if([net stock]>[Outstanding Order],[Outstanding Order],[net stock])

if you can give me pseudo code then we can help much better.Because from your requirement its not too clear to understand.

Thanks,

Raghvendra

Wed, 07 Oct 2015 17:12:31 GMT

Hi,

the format of if condition in qlikview is

IF(condition block, true block, else block),

try to use this

if(isnull(net stock)=-1,null(),if(net stock > Outstanding Order,Outstanding Order,net stock))

with best regards

maxgro — Wed, 07 Oct 2015 17:30:51 GMT

if(sum(Netstock)=0, null(), rangemin(sum(Netstock) , sum([Outstanding Order]) ) )

MarcoWedel — Wed, 07 Oct 2015 21:20:52 GMT

please post sample data and expected result.

regards

Marco