Convert SQL Query to Qlikview Script (No SQL access)

Mon, 27 Mar 2017 20:38:45 GMT

Hi,

I don't have SQL access, but have a former employee's SQL query that I'd like to convert into QlikView script. I am including a segment of the script below:

,[PrinDxCode]

,[PrinDxDesc]

,CASE WHEN [PrinDxDesc] LIKE '%Metastatic%' THEN 'Metastatic'

WHEN [PrinDxDesc] LIKE '%SEC%' THEN 'Metastatic'

WHEN [PrinDxDesc] IS NULL THEN 'NULL'

ELSE 'Primary' END AS 'Metastatic'

,CASE WHEN [PrinDxCode] LIKE '140%' THEN 'Lip'

WHEN [PrinDxCode] LIKE '141%' THEN 'Tongue'

,[SecDx1Code]

,CASE WHEN [SecDx1Code] LIKE '140%' THEN 'Lip'

WHEN [SecDx1Code] BETWEEN '1642%' AND '1649%' THEN 'Mediastinum'

ELSE NULL END AS 'Sec1Category' ELSE NULL END AS 'Principle'

Re: Convert SQL Query to Qlikview Script (No SQL access)

vishsaggi — Mon, 27 Mar 2017 21:11:23 GMT

May be try this? If not can you share some sample data with expected output?

IF(Wildmatch([PrinDxDesc], '*Metastatic*', '*SEC*') >=1, 'Metastatic', IF(Len(Trim([PrinDxDesc])) = 0, 'Null', 'Primary')) AS Metastatic,

IF(WildMatch([PrinDxCode], '140*') >= 1, 'Lip', IF(WildMatch([PrinDxCode], '141*') >= 1, 'Tongue')) AS PrinDxCode,

[SecDx1Code],

IF(WildMatch([SecDx1Code], '140*') >=1, 'Lip', IF([SecDx1Code] >= (1642*10) AND [SecDx1Code] <= (1649*10), 'Mediastinum', Null)) AS Sec1Category

topic Convert SQL Query to Qlikview Script (No SQL access) in QlikView

Convert SQL Query to Qlikview Script (No SQL access)

Re: Convert SQL Query to Qlikview Script (No SQL access)