Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

crowegreg
New Contributor II

Load & Concatanation

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
INC12449518St. Francis Hospital Federal Way ; Family Birthing CenterRegion 5(WA,OR)

I've been able to group on the site, but can't figure out how to add the Region field.

1 Reply

Re: Load & Concatanation

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;

Community Browser