Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
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
MVP
MVP

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?