Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources. READ DETAILS
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])

 

View solution in original post