need help to write the expression

[suvechha_b]

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]

maybe something like

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

[raghvendrasingh]

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

[#4 · Accepted solution]

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]

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

[MarcoWedel]

please post sample data and expected result.

regards

Marco