Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm having difficulty getting the data into Qlik Sense as required by my existing dashboards.
Here are my current load statements:
Sitelist:
Load
dv_task as [Source Incident] ,dv_location as Site;
SQL
SELECT
dv_task ,dv_location
FROM
task_location
WHERE dv_task = 'INC12449518';
left Join (Sitelist)
Load
full_name as Site
,pick(WildMatch(u_region
,'*5*'
)
,'Region 5 (WA,OR)'
) as Region;
SQL
SELECT
full_name
,u_region
FROM
cmn_location
WHERE
"u_active" <> '0';
The results are the following:
Here's what I'm needing:
Source Incident | Site | Region |
---|---|---|
INC12449518 | St. Francis Hospital Federal Way ; Family Birthing Center | Region 5(WA,OR) |
I've been able to group on the site, but can't figure out how to add the Region field.
After the code that you already have, try adding this:
Sitelist_Final:
LOAD [Source Incident],Region,
CONCAT(Site, '; ') AS Site
RESIDENT Sitelist
GROUP BY [Source Incident], Region;
DROP TABLE Sitelist;