convert sql to qlik expression

[lprasanth]

Hi all,

I want the following to be converted to QlikView expression. Any help would be very much appreciated

Sum of [Orders] where StatutPoolingEdi ='Ok pooling' / Sum of [idPoolingEdiOrders]
where StatutPoolingEdi ='Non Poolable' and  'Ok pooling'

[sergio0592]

Hi,

You want in your load statement or in front end syntax?

[lprasanth]

Hi, i want it in the chart expressio

[neelamsaroha157 · Accepted solution]

If you are trying it ion the front end expression then you may try set analysis-

Sum( {<StatutPoolingEdi  = {'Ok pooling'}>}[Orders])/Sum( {<StatutPoolingEdi  = {'Non Poolable', 'Ok pooling'}>}[idPoolingEdiOrders])