Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

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
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
Partner - Champion III
Partner - Champion III

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
Specialist III
Specialist III

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