I'm having difficulty getting the data into Qlik Sense as required by my existing dashboards.
Here are my current load statements:
dv_task as [Source Incident] ,dv_location as Site;
WHERE dv_task = 'INC12449518';
left Join (Sitelist)
full_name as Site
,'Region 5 (WA,OR)'
) as Region;
"u_active" <> '0';
The results are the following:
Here's what I'm needing:
|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.