topic Re: Garbage after statement in QlikView

Garbage after statement

Wed, 29 Aug 2012 14:47:20 GMT

Hello,

Can anyone tell me why I am getting a Garbage after statement on the following lines in the load script?

QUALIFY *;

NSOProvider:

LOAD BreakoutProviderSideActivity.ID,

BreakoutProviderSideActivity.Week,

BreakoutProviderSideActivity.Employee,

BreakoutProviderSideActivity.Team,

if([BreakoutProviderSideActivity.Team]='CVN','NSO') or

if([BreakoutProviderSideActivity.Team]='OS','NSO') as BreakoutProviderTeam,

[BreakoutProviderSideActivity.Days Booked]

RESIDENT

BreakoutProviderSideActivity

Where [BreakoutProviderSideActivity.Team] in('CVN','OS','NSO');

UNQUALIFY *;

Re: Garbage after statement

Wed, 29 Aug 2012 15:38:01 GMT

It seams to me that you use the IN where clause like in SQL. In qlikview you can use the match syntax. So in your case replace:

Where [BreakoutProviderSideActivity.Team] in('CVN','OS','NSO');

Where match([BreakoutProviderSideActivity.Team], 'CVN','OS','NSO');

you can also change your if by:

'NSO' as BreakoutProviderTeam

because you are alseady filtering 'OS' and 'CVN' in your where condition

Re: Garbage after statement

Wed, 29 Aug 2012 15:56:29 GMT

On the NSO I want that data, but where the team is CVN or OS I am changing the team to equal NSO. Will the way I am doing this actually work? I want to roll everything on CVN and OS teams up to NSO.

Thank you so much in advance.