Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

suvechha_b
Contributor II

how to write it in expression in qlikview

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

3 Replies

Re: how to write it in expression in qlikview

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

MVP
MVP

Re: how to write it in expression in qlikview

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.

Highlighted
gautik92
Valued Contributor III

Re: how to write it in expression in qlikview

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