I would like you to help me understand how to perform the following SQL in Qlik.
WITH HISTORIA_ESTADOS AS ( SELECT ROW_NUMBER() OVER(PARTITION BY WOS.WONUM ORDER BY WOS.CHANGEDATE) ||'-' ||WO.WONUM AS LINEA ,(ROW_NUMBER() OVER(PARTITION BY WOS.WONUM ORDER BY WOS.CHANGEDATE))-1 ||'-' ||WO.WONUM AS LINEA2 , WO.WONUM OT , WO.DESCRIPTION DESC_OT , WOS.STATUS , WOS.CHANGEDATE , WOS.CHANGEBY , WO.SLXGRRESP GROT , PG.DESCRIPTION DESC_GROT , P.DISPLAYNAME , WO.STATUSDATE , WO.STATUS ESTADO_OT FROM
MAXIMO.WORKORDER WO , MAXIMO.WOSTATUS WOS , MAXIMO.PERSON P , MAXIMO.PERSONGROUP PG WHERE WO.WONUM = WOS.WONUM AND WO.SLXGRRESP = PG.PERSONGROUP (+) AND WOS.CHANGEBY = P.PERSONID (+) AND WO.ISTASK IN '0' ) SELECT A.OT , A.DESC_OT , A.ESTADO_OT ESTADO_ACTUAL , A.GROT , A.DESC_GROT , A.STATUS ESTADO_1 , A.CHANGEDATE FECHA_1 , B.CHANGEDATE-A.CHANGEDATE DURACION_ESTADO_DIAS , B.STATUS ESTADO_2 , B.CHANGEDATE FECHA_2 , B.CHANGEBY CC_RESPONSABLE , B.DISPLAYNAME RESPONSABLE_ESTADO FROM HISTORIA_ESTADOS A LEFT JOIN HISTORIA_ESTADOS B ON A.LINEA = B.LINEA2 WHERE B.CHANGEDATE IS NOT NULL
