how to write it in expression in qlikview

[suvechha_b]

How to write the following in qliview expression :

if(t_distributor='ACW',

     if(sum(qty_available)<sum([OutStanding Qty]),'NO','YES'),

if(t_distributor='UPD' ,

     if(sum(qty_available)<sum([upd_outstanding_order_qty]),'NO','YES'),

     if(sum(qty_available)<sum([outstanding_order_qty]),'NO','YES')))

[sunny_talwar]

Looks like a correct expression to me to be used in QlikView. Is it not giving you the results you are expecting to see?

[petter]

It all depends on the context of the expression whether it works as you expect it to.

Is this an expression in a chart and if yes what are the dimensions?

The only direct possible problematic part of your expression is the t_distributor = 'UPD' it should be an aggregation for the t_distributor field like for instance Only() or MinString() / MaxString() or something - but it all depends on context.

[gautik92]

i hope it will give the expected output....you dint get?