topic Re: Matching Multiple Instances Issue in QlikView

Matching Multiple Instances Issue

Mon, 01 Jun 2015 15:39:11 GMT

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

Name	Description	Scheduled Start Time	Scheduled End Time
Run1	ABC	13:14:15	15:45:18
Run2	ABC	13:14:15	15:45:18
Run3	ABC	13:14:15	15:45:18
Run4	ABC	13:14:15	15:45:18

Actual Runs

Name	Status	Actual Start Time	Actual End Time
Run1	C	13:14:15	15:45:18
Run1	C	13:14:15	15:45:18
Run1	F	13:14:15	15:45:18
Run2	F	13:14:15	15:45:18
Run2	C	13:14:15	15:45:18
Run6	C	13:14:15	15:45:18
Run7	C	13:14:15	15:45:18

Any assistance is greatly appreciated.

Kind regards,

Tristan Breslin

Re: Matching Multiple Instances Issue

maxgro — Mon, 01 Jun 2015 15:51:32 GMT

load scheduled runs

then load actual run where exists(Name)

Re: Matching Multiple Instances Issue

alexandros17 — Mon, 01 Jun 2015 15:54:37 GMT

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

Re: Matching Multiple Instances Issue

petter — Mon, 01 Jun 2015 22:31:20 GMT

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))

Re: Matching Multiple Instances Issue

MarcoWedel — Mon, 01 Jun 2015 23:08:07 GMT

Hi,

some possible solutions without joining:

hope this helps

regards

Marco

Re: Matching Multiple Instances Issue

Tue, 02 Jun 2015 13:09:14 GMT

Thank you Marco, very much appreciated!

Re: Matching Multiple Instances Issue

MarcoWedel — Tue, 02 Jun 2015 15:02:24 GMT

you're welcome

regards

Marco