Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'
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