topic Linking to Date Fields in QlikView

Linking to Date Fields

Wed, 08 Jun 2011 11:51:34 GMT

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

Linking to Date Fields

stephencredmond — Wed, 08 Jun 2011 13:47:13 GMT

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

Linking to Date Fields

stephencredmond — Wed, 08 Jun 2011 13:48:10 GMT

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

Linking to Date Fields

Wed, 08 Jun 2011 14:46:57 GMT

Thankyou for youe help.

Worked a treat.

Rich