topic Re: Assigning a value to a key field in QlikView

Assigning a value to a key field

Wed, 29 Aug 2012 17:25:09 GMT

Can anyone tell me why I don't get values from my team field when the following statement is true. I only get zeros when it isn't met. So if the BreakoutProviderSideActivity.Team is equal to CVN then I want BreakoutTeam to equal NSO. Any ideas?

LOAD BreakoutProviderSideActivity.ID,

BreakoutProviderSideActivity.Week,

BreakoutProviderSideActivity.Employee,

BreakoutProviderSideActivity.Team,

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

if(BreakoutProviderSideActivity.Team='OS','NSO',0) or

if([BreakoutProviderSideActivity.Team]='PDS','PED',0) or

if([BreakoutProviderSideActivity.Team]='MFM','OBG',0) or

if([BreakoutProviderSideActivity.Team]='GST','GRI',0) or

if([BreakoutProviderSideActivity.Team]='ORE','GRI',0) as BreakoutTeam,

[BreakoutProviderSideActivity.Days Booked]

FROM

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

(qvd);

Re: Assigning a value to a key field

chematos — Wed, 29 Aug 2012 17:31:16 GMT

May be this helps to you

http://www.qlikblog.at/tools/Nested-If-Generator.html

Re: Assigning a value to a key field

whiteline — Wed, 29 Aug 2012 18:15:13 GMT

You didn't write the expression for that.

Consider BreakoutProviderSideActivity.Team='CVN'

Evaluate your expression for BreakoutTeam:

if('CVN'='CVN','NSO',0) or

if('CVN'='OS','NSO',0) or

if('CVN'='PDS','PED',0) or

if('CVN'='MFM','OBG',0) or

if('CVN'='GST','GRI',0) or

if('CVN'='ORE','GRI',0)

next step:

'NSO' or 0 or 0 or 0 or 0 or 0

the result is NULL.

upd:

I suppose you want this:

if(BreakoutProviderSideActivity.Team='CVN','NSO',

if(BreakoutProviderSideActivity.Team='OS','NSO',

if(BreakoutProviderSideActivity.Team='PDS','PED',

if(BreakoutProviderSideActivity.Team='MFM','OBG',

if(BreakoutProviderSideActivity.Team='GST','GRI',

if(BreakoutProviderSideActivity.Team='ORE','GRI',0))))))