Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Matching Multiple Instances Issue

Hello,

I've got two tables, one with a schedule, and one with a list of runs. They both have 'Name' as a key, and I've been trying to use a left join to match them. This has worked to get a list of all the Scheduled Runs and a Count of how many Actual Runs have taken place against it.

However I need to get a table that contains a list of Actual Runs - but only those that are contained in the Scheduled Runs table. So in the example below, I need a table containing all the instances of "Run1" and "Run2".

Scheduled Runs

NameDescriptionScheduled Start TimeScheduled End Time
Run1ABC13:14:1515:45:18
Run2ABC13:14:1515:45:18
Run3ABC13:14:1515:45:18
Run4ABC13:14:1515:45:18

Actual Runs

NameStatusActual Start TimeActual End Time
Run1C13:14:1515:45:18
Run1C13:14:1515:45:18
Run1F13:14:1515:45:18
Run2F13:14:1515:45:18
Run2C13:14:1515:45:18
Run6C13:14:1515:45:18
Run7C13:14:1515:45:18

Any assistance is greatly appreciated.

Kind regards,

Tristan Breslin

1 Solution

Accepted Solutions
MarcoWedel

Hi,

some possible solutions without joining:

QlikCommunity_Thread_166337_Pic1.JPG

QlikCommunity_Thread_166337_Pic4.JPG

QlikCommunity_Thread_166337_Pic2.JPG

QlikCommunity_Thread_166337_Pic3.JPG

hope this helps

regards

Marco

View solution in original post

6 Replies
maxgro
MVP
MVP

load scheduled runs

then load actual run where exists(Name)

alexandros17
Partner - Champion III
Partner - Champion III

Inner Join instead of left join will return only records contained in both tables

petter
Partner - Champion III
Partner - Champion III

You can create a straight table with

One dimension:

     Name

One Expression:

     If(Count({<Status={A,C,F}>}Name)>0 AND Count({<Description={"*"}>} Description)>0,Count(Status))

MarcoWedel

Hi,

some possible solutions without joining:

QlikCommunity_Thread_166337_Pic1.JPG

QlikCommunity_Thread_166337_Pic4.JPG

QlikCommunity_Thread_166337_Pic2.JPG

QlikCommunity_Thread_166337_Pic3.JPG

hope this helps

regards

Marco

Not applicable
Author

Thank you Marco, very much appreciated!

MarcoWedel

you're welcome

regards

Marco