Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Linking to Date Fields

I am having difficulty with the attached qvd.

The quality table is not linking in properly with teh rest of the data. I have created the neccessary links but cannot seem to pull data for Quality scores against agents, whilst also producing other kPI data.

Can anyone see anything obvious that I am missing?

Any help would be much appreciated.

Kind Regards

Richard

Tags (1)
1 Solution

Accepted Solutions
Luminary
Luminary

Linking to Date Fields

Hi,

In your Quality table you are using:

   Month&[AgentID] as %Key_Quality

To generate the key.  The Month is a cross table value from Excel which is a date in Integer format.

In the Link table you are using:

   MonthStart(Date(RecvdDate))&CallLogAgentID as %Key_Quality,

So the month is in a date format.  Quick change is to floor the month:

   Floor(MonthStart(Date(RecvdDate)))&CallLogAgentID as %Key_Quality,

Should be good to go.

Regards,

Stephen

3 Replies
Luminary
Luminary

Linking to Date Fields

Hi,

In your Quality table you are using:

   Month&[AgentID] as %Key_Quality

To generate the key.  The Month is a cross table value from Excel which is a date in Integer format.

In the Link table you are using:

   MonthStart(Date(RecvdDate))&CallLogAgentID as %Key_Quality,

So the month is in a date format.  Quick change is to floor the month:

   Floor(MonthStart(Date(RecvdDate)))&CallLogAgentID as %Key_Quality,

Should be good to go.

Regards,

Stephen

Luminary
Luminary

Linking to Date Fields

BTW if you put the Date key value and values from Quality and the Key table into a table box, you would see the disconnect very quickly.

Regards,

Stephen

Not applicable

Linking to Date Fields

Thankyou for youe help.

Worked a treat.

Rich