topic Re: convert sql to qlik expression in QlikView

convert sql to qlik expression

lprasanth — Sat, 16 Nov 2024 02:34:58 GMT

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 — Tue, 03 Sep 2019 13:25:04 GMT

Hi,

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

lprasanth — Tue, 03 Sep 2019 13:30:34 GMT

Hi, i want it in the chart expressio

neelamsaroha157 — Tue, 03 Sep 2019 13:31:05 GMT

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