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: 
lprasanth
Contributor II
Contributor II

convert sql to qlik expression

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'

Labels (2)
1 Solution

Accepted Solutions
neelamsaroha157
Specialist II
Specialist II

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

 

View solution in original post

3 Replies
sergio0592
Specialist III
Specialist III

Hi,

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

lprasanth
Contributor II
Contributor II
Author

Hi, i want it in the chart expressio
neelamsaroha157
Specialist II
Specialist II

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