topic Selecting Data not 1:1 related in QlikView

Selecting Data not 1:1 related

Thu, 15 Mar 2012 07:30:28 GMT

Hi,

i have a mastercalender, so other tables are connectet 1:1 per date (one field).

I have a Leader Table.

Now i have the following (seminar) table, who may connectet by more then one field.

SeminarID

Startdate

Enddate

Leader 1

Leader 2

Leader 3

Leader 4

Leader 5

I have to verify, if the selected date in the mastercalender ist BETWEEN the startdate/enddate, and only showing this data.

On the other hand, i have to verify, if the selected Leader is in one of the 5 fields above (so maybe a i get a $SYNTH Table?), and only showing this data.

How can i integrate my seminartable in my QVW correctly?

Regards,

Michael

Selecting Data not 1:1 related

Thu, 15 Mar 2012 15:52:55 GMT

Use the function intervalmatch(). That will do the first one.

which field do you pick up when you say "if the selected Leader"?

Selecting Data not 1:1 related

Fri, 16 Mar 2012 13:12:36 GMT

I don't get it how the funktion intervalmatch() works.

Here my script (simple):

Load
     TicketID,
     Datum
from Tickes;
Load
     LeaderID,
     Leadername,
from Leaders
Load
     Datum,
     Year,
     Quarter,
     Month,
     Week,
     Day
from Mastercalender
Load
     SeminarID,
     Seminar_Startdate,
     Seminar_Enddate,
     Leader1,
     Leader2,
     Leader3,
     Leader4,
     Leader5
from Seminar

The table "Seminar" is not directly connected to the other two tables.

Please help me, how i can use the function intervallmatch() in this script.

For the Leader-Selection:

I select "Leadername" and want to verify, if "LeaderID" is in one of the Fields "Leader 1" to "Leader 5".

Regards,

Michael

Re: Selecting Data not 1:1 related

Fri, 16 Mar 2012 13:35:21 GMT

Hi,

please find an example with the function attached. You also can use the documentation, it's really helpfull.

Selecting Data not 1:1 related

Sat, 17 Mar 2012 19:40:10 GMT

Hi,

thanks for the example. Thanks to that, i have now an integrated seminar-table (by intervalmatch (date)).

Now, how can i connect the LeaderID to all possible 5 Leaderfields?

If i make another intervalmatch function, i get a loop.

Is there a possibility?

Regards,

Michael

Selecting Data not 1:1 related

Sun, 18 Mar 2012 07:12:00 GMT

Could you give a data example?

Are yours 5 leader fieds <> null in the same time? There is more than one fill?

Re: Selecting Data not 1:1 related

Wed, 11 Apr 2012 19:05:33 GMT

Hi,

sorry for late example.

I want to select "Hans" in Leader.

If selected, all possible Seminars shoud be selected too, where "Hans" could be in Leader1, Leader2 or Leader3.

Regards

Michael