Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
dana8315
New Contributor II

I have only two tables to join but I have more than one key needed

 

DateSiteSupervisorSegmentANSCallTypeFormTypeCoachingErrorTypeCallInfoTypeSegment

CallId

 

 

DateSiteSupervisorSegmentANS

 

I have two tables above.  The first table (Errors) has a measure of count(CoachingErrorType) and the second table (Calls) has a measure of SUM(ANS).  What I'm trying to do is get an error percentage of the sum(ans) which is the error percentage of total calls eventually Count(CoachingErrorType)/Sum(ANS) and then be able to drill down by site, supervisor, date, and segment.  I can join on one key and get the results I need, but I want to be able to drill down by site, supervisor, and segment.  How can I do this if I only have one key.  I tried joining the tables on multiple columns I tried two at first ( see below) but that didn't give the results I was looking for.  I am still getting duplicate supervisor columns, etc. 

Errors:
LOAD
 AutoNumber(Supervisor&Segment) as Key,
    DateCompleted,
    CallDate,
    AddedBy,
    AgentName,
    [Supervisor] as Errors_Supervisor,
    Location,
    CallType,
    FormType,
    CoachingDetails,
    CoachingErrorType,
    CallInfoType,
    CreditUnionName,
    [Segment] as Errors_Segment,
    CallId
FROM [path], table is Errors);

 

Right Join
LOAD
 AutoNumber(Supervisor&Segment) as Key,
    "Date",
    Site,
    [Supervisor] as [Calls_Supervisor],
    [Segment] as [Calls_Segment],
    ANS
FROM [path]
(ooxml, embedded labels, table is Calls);

 

Labels (3)
3 Replies
Partner
Partner

Re: I have only two tables to join but I have more than one key needed

You might want to include all four fields in your join
AUTONUMBERHASH256(Date,Site,Supervisor,Segment) As Key
#OnVacation #BetweenJobs.
Please ekskuse my Norglish and Swenglish typos.
Community Manager
Community Manager

Re: I have only two tables to join but I have more than one key needed

@dana8315  Are you using QlikView or Sense? I would like to move this into the correct product forum. Thank you. 

Sue Macaluso
dana8315
New Contributor II

Re: I have only two tables to join but I have more than one key needed

I'm using Qlik Sense.  🙂