Converting SQL script/function in Qlik

pawwy1415 — Wed, 07 Mar 2018 12:25:30 GMT

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,

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

topic Converting SQL script/function in Qlik in QlikView