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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
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