Resident table question

Tue, 28 Aug 2012 14:07:48 GMT

I am using the Resident table to redifine certain teams Days Booked into other fields. I want my fields to pick up the label. For example I want CNVClient.BreakoutClientSideActivity.Days Booked. Below is the logic in the report script I am using. I can't get it to pick up the label. Any ideas?

BreakoutClientSideActivity:

LOAD BreakoutClientSideActivity.ID,

BreakoutClientSideActivity.Week,

BreakoutClientSideActivity.Employee,

BreakoutClientSideActivity.Team,

[BreakoutClientSideActivity.Days Booked]

FROM

[\\slcnasp01\Qlikview_Data\qliktech_user\DavidHill_Dev\2_Loaders-QVW\QVDs\BreakoutClientSideActivity.qvd]

(qvd);

CVNClient:

LOAD BreakoutClientSideActivity.ID,

BreakoutClientSideActivity.Week,

BreakoutClientSideActivity.Employee,

BreakoutClientSideActivity.Team,

if([BreakoutClientSideActivity.Team]='CVN','NSO') as Team ,

[BreakoutClientSideActivity.Days Booked]

RESIDENT

BreakoutClientSideActivity;

Re: Resident table question

Tue, 28 Aug 2012 14:11:33 GMT

Try the following, using the QUALIFY statement:

BreakoutClientSideActivity:

LOAD BreakoutClientSideActivity.ID,

BreakoutClientSideActivity.Week,

BreakoutClientSideActivity.Employee,

BreakoutClientSideActivity.Team,

[BreakoutClientSideActivity.Days Booked]

FROM

[\\slcnasp01\Qlikview_Data\qliktech_user\DavidHill_Dev\2_Loaders-QVW\QVDs\BreakoutClientSideActivity.qvd]

(qvd);

QUALIFY *;

CVNClient:

LOAD BreakoutClientSideActivity.ID,

BreakoutClientSideActivity.Week,

BreakoutClientSideActivity.Employee,

BreakoutClientSideActivity.Team,

if([BreakoutClientSideActivity.Team]='CVN','NSO') as Team ,

[BreakoutClientSideActivity.Days Booked]

RESIDENT

BreakoutClientSideActivity;

UNQUALIFY *;

topic Resident table question in QlikView

Resident table question

Re: Resident table question