Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
maybe something like
=RangeMin( Sum([Outstanding Order]), Sum([Net Stock]) )
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
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
if(sum(Netstock)=0, null(), rangemin(sum(Netstock) , sum([Outstanding Order]) ) )
please post sample data and expected result.
regards
Marco