Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Garbage after statement

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 *;

2 Replies
Not applicable
Author

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'); 

by

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

Not applicable
Author

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.