Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'
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])
Hi,
You want in your load statement or in front end syntax?
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])