https://community.qlik.com/t5/Search-the-Community/SQL-Statement-to-Qlik-Script/m-p/1809247#M324 <P>Hello,</P><P>I would like you to help me understand how to perform the following SQL in Qlik.</P><P>&nbsp;</P><P>WITH HISTORIA_ESTADOS AS<BR />(<BR />SELECT<BR />ROW_NUMBER() OVER(PARTITION BY WOS.WONUM ORDER BY<BR />WOS.CHANGEDATE)<BR />||'-'<BR />||WO.WONUM AS LINEA<BR />,(ROW_NUMBER() OVER(PARTITION BY WOS.WONUM ORDER BY<BR />WOS.CHANGEDATE))-1<BR />||'-'<BR />||WO.WONUM AS LINEA2<BR />, WO.WONUM OT<BR />, WO.DESCRIPTION DESC_OT<BR />, WOS.STATUS<BR />, WOS.CHANGEDATE<BR />, WOS.CHANGEBY<BR />, WO.SLXGRRESP GROT<BR />, PG.DESCRIPTION DESC_GROT<BR />, P.DISPLAYNAME<BR />, WO.STATUSDATE<BR />, WO.STATUS ESTADO_OT<BR />FROM</P><P>MAXIMO.WORKORDER WO<BR />, MAXIMO.WOSTATUS WOS<BR />, MAXIMO.PERSON P<BR />, MAXIMO.PERSONGROUP PG<BR />WHERE<BR />WO.WONUM = WOS.WONUM<BR />AND WO.SLXGRRESP = PG.PERSONGROUP (+)<BR />AND WOS.CHANGEBY = P.PERSONID (+)<BR />AND WO.ISTASK IN '0'<BR />)<BR />SELECT<BR />A.OT<BR />, A.DESC_OT<BR />, A.ESTADO_OT ESTADO_ACTUAL<BR />, A.GROT<BR />, A.DESC_GROT<BR />, A.STATUS ESTADO_1<BR />, A.CHANGEDATE FECHA_1<BR />, B.CHANGEDATE-A.CHANGEDATE DURACION_ESTADO_DIAS<BR />, B.STATUS ESTADO_2<BR />, B.CHANGEDATE FECHA_2<BR />, B.CHANGEBY CC_RESPONSABLE<BR />, B.DISPLAYNAME RESPONSABLE_ESTADO<BR />FROM<BR />HISTORIA_ESTADOS A<BR />LEFT JOIN<BR />HISTORIA_ESTADOS B<BR />ON<BR />A.LINEA = B.LINEA2<BR />WHERE<BR />B.CHANGEDATE IS NOT NULL</P><P>&nbsp;</P> Wed, 19 May 2021 20:43:19 GMT jdvasquez 2021-05-19T20:43:19Z https://community.qlik.com/t5/Search-the-Community/SQL-Statement-to-Qlik-Script/m-p/1809247#M324 <P>Hello,</P><P>I would like you to help me understand how to perform the following SQL in Qlik.</P><P>&nbsp;</P><P>WITH HISTORIA_ESTADOS AS<BR />(<BR />SELECT<BR />ROW_NUMBER() OVER(PARTITION BY WOS.WONUM ORDER BY<BR />WOS.CHANGEDATE)<BR />||'-'<BR />||WO.WONUM AS LINEA<BR />,(ROW_NUMBER() OVER(PARTITION BY WOS.WONUM ORDER BY<BR />WOS.CHANGEDATE))-1<BR />||'-'<BR />||WO.WONUM AS LINEA2<BR />, WO.WONUM OT<BR />, WO.DESCRIPTION DESC_OT<BR />, WOS.STATUS<BR />, WOS.CHANGEDATE<BR />, WOS.CHANGEBY<BR />, WO.SLXGRRESP GROT<BR />, PG.DESCRIPTION DESC_GROT<BR />, P.DISPLAYNAME<BR />, WO.STATUSDATE<BR />, WO.STATUS ESTADO_OT<BR />FROM</P><P>MAXIMO.WORKORDER WO<BR />, MAXIMO.WOSTATUS WOS<BR />, MAXIMO.PERSON P<BR />, MAXIMO.PERSONGROUP PG<BR />WHERE<BR />WO.WONUM = WOS.WONUM<BR />AND WO.SLXGRRESP = PG.PERSONGROUP (+)<BR />AND WOS.CHANGEBY = P.PERSONID (+)<BR />AND WO.ISTASK IN '0'<BR />)<BR />SELECT<BR />A.OT<BR />, A.DESC_OT<BR />, A.ESTADO_OT ESTADO_ACTUAL<BR />, A.GROT<BR />, A.DESC_GROT<BR />, A.STATUS ESTADO_1<BR />, A.CHANGEDATE FECHA_1<BR />, B.CHANGEDATE-A.CHANGEDATE DURACION_ESTADO_DIAS<BR />, B.STATUS ESTADO_2<BR />, B.CHANGEDATE FECHA_2<BR />, B.CHANGEBY CC_RESPONSABLE<BR />, B.DISPLAYNAME RESPONSABLE_ESTADO<BR />FROM<BR />HISTORIA_ESTADOS A<BR />LEFT JOIN<BR />HISTORIA_ESTADOS B<BR />ON<BR />A.LINEA = B.LINEA2<BR />WHERE<BR />B.CHANGEDATE IS NOT NULL</P><P>&nbsp;</P> Wed, 19 May 2021 20:43:19 GMT https://community.qlik.com/t5/Search-the-Community/SQL-Statement-to-Qlik-Script/m-p/1809247#M324 jdvasquez 2021-05-19T20:43:19Z