Converting SQL script/function in Qlik

[pawwy1415]

Hi,

Could you please help how we can convert following SQL script into Qlik:

this is in sql

DECLARE @COLS NVARCHAR(MAX)

SELECT  @COLS = COALESCE(@COLS + ',[' + CFNAME  + ']',

                        '[' + CFNAME + ']')

FROM   CUSTOMFIELD

WHERE CFNAME NOT IN ('Time in Status', 'ToolBar')

GROUP BY CFNAME

------------------------------------------------

JOIN

(SELECT T2.ISSUE ISSUEID

      , T1.CFNAME

      , (CASE

WHEN [STRINGVALUE] IS NOT NULL

THEN CAST ([STRINGVALUE] AS NVARCHAR(1024)) 

WHEN [DATEVALUE] IS NOT NULL

THEN CAST ([DATEVALUE] AS NVARCHAR(1024))

WHEN [NUMBERVALUE] IS NOT NULL

THEN CAST ([NUMBERVALUE] AS NVARCHAR(1024))

WHEN [TEXTVALUE] IS NOT NULL

THEN CAST ([TEXTVALUE] AS NVARCHAR(4000))

ELSE '' '' 

END) VALUE

FROM CUSTOMFIELD AS T1

      JOIN CUSTOMFIELDVALUE AS T2 ON T1.ID = T2.CUSTOMFIELD) P

     PIVOT

(

MAX([VALUE])

FOR CFNAME IN

( '+@COLS +' )                  -- this is declared on top

) AS PVT

ON JIRAISSUE.ID = PVT.ISSUEID;'

----------------------------------------------------------------------

2., ISNULL(CAST (JIRAISSUE.REPORTER AS NVARCHAR(4000)), '' '') REPORTER

Thanks,

---------------------------------------