Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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?