topic how to write it in expression in qlikview in QlikView

how to write it in expression in qlikview

suvechha_b — Mon, 12 Oct 2015 09:01:20 GMT

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')))

Re: how to write it in expression in qlikview

sunny_talwar — Mon, 12 Oct 2015 09:04:30 GMT

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

Re: how to write it in expression in qlikview

petter — Mon, 12 Oct 2015 09:04:52 GMT

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.

Re: how to write it in expression in qlikview

gautik92 — Mon, 12 Oct 2015 09:06:47 GMT

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