topic Multiple Link in QlikView

Multiple Link

rash_611 — Tue, 30 Jun 2015 05:16:32 GMT

Hi Team,

I have a concern while linking the table Kindly help me. Below is the table structure.

Asset Master -> Hostname, Asset Category, Domain, Location

Call Details-> Ticket ID, Open Date, Status, Close Date, Hostname

Monitoring -> Hostname, Metrics, Value, LogDate

LinkTable--> ID, Date

I want to link Asset Master, call details and Monitoring table through Hostname and want to Link OpenDate, LogDate to LinkTab to create the calender.

Kindly suggest how to do that since it is creating syn.Key or circular Link.

Regards,

Grace@

Re: Multiple Link

tresB — Tue, 30 Jun 2015 05:34:19 GMT

Try like:

[Asset Master]:

Load

    Hostname,

     [Asset Category],

     Domain,

     Location

From <>;

[Call Details]:

Load

     Hostname,

     Hostname as HostLink,

     [Ticket ID],

     [Open Date],

     [Close Date],

     Status

From <>;

[Monitoring]:

Load

    Hostname as HostLink,

     Metrics,

     Value,

     LogDate as Date

From <>;

[DateTable]:

Load

     ID,

    Date

From <>;

Re: Multiple Link

rash_611 — Tue, 30 Jun 2015 05:42:39 GMT

but i have to link the [Open Date] and [Close Date] also for Date for Calender purpose..

Re: Multiple Link

tresB — Tue, 30 Jun 2015 05:50:13 GMT

For that you could take any(that fits your need) out of couple of approaches, like:

- create mutiple calendars for each date type

- create a link table for dates, see details here: Canonical Date

- create multiple date fields in one calendar table itself. May be like:

Load

Date,

Date as [Open Date],

Date as [Close Date]

...;