How can i convert this query to qlikview

Tue, 05 May 2015 08:52:49 GMT

PO_ALL:

SELECT MPL.IBCONO COMPANY_NO, MPL.IBFACI FACILITY, MPL.IBITNO ITEM_NUMBER,

(SELECT MAX(MO.AHATAV)

FROM M3EDBPRD.MOATTR MO

WHERE MO.AHATNR = MPL.IBATNR AND MO.AHCONO = MPL.IBCONO

AND IBCONO = '500' AND IBPUSL BETWEEN '15' AND '49'

And IBFACI Not In ('A1', 'G2', 'G3', 'G4', 'G5', 'G6', 'G7', 'G8', 'G9')) PUT_AWAY_CODE,

MPD.PMMTNO PRODUCT,

MPD.PMCNQT QUANTITY,

ROUND((SUM(CASE WHEN MPL.IBCFQA = 0 THEN MPL.IBORQA ELSE MPL.IBCFQA END - MPL.IBRVQA)) * (MPD.PMCNQT/(SELECT SUM(MPDM.PMCNQT) FROM M3EDBPRD.MPDMAT MPDM WHERE MPDM.PMCONO = MPL.IBCONO AND MPDM.PMFACI = MPL.IBFACI

AND MPDM.PMPRNO = MPL.IBITNO)),2) WIP

FROM M3EDBPRD.MPLINE MPL

LEFT OUTER JOIN M3EDBPRD.MPDMAT MPD

ON MPL.IBCONO = MPD.PMCONO AND MPL.IBFACI = MPD.PMFACI

AND MPL.IBITNO = MPD.PMPRNO

WHERE MPL.IBCONO = '500'

AND MPL.IBPUSL BETWEEN '15' AND '49'

AND MPL.IBFACI Not In ('A1', 'G2', 'G3', 'G4', 'G5', 'G6', 'G7', 'G8', 'G9')

GROUP BY MPL.IBCONO, MPL.IBFACI, MPL.IBITNO,

(SELECT MAX(MO.AHATAV)

FROM M3EDBPRD.MOATTR MO

WHERE MO.AHATNR = MPL.IBATNR AND MO.AHCONO = MPL.IBCONO

AND IBCONO = '500' AND IBPUSL BETWEEN '15' AND '49'

And IBFACI Not In ('A1', 'G2', 'G3', 'G4', 'G5', 'G6', 'G7', 'G8', 'G9')),

MPD.PMMTNO, MPD.PMCNQT

Re: How can i convert this query to qlikview

Tue, 05 May 2015 09:00:46 GMT

Please help me how to convert this.

topic How can i convert this query to qlikview in QlikView

How can i convert this query to qlikview

Re: How can i convert this query to qlikview