topic If condition in a load script in QlikView

If condition in a load script

Wed, 08 Aug 2012 16:00:23 GMT

Hi,

I would like to calculate and add a field in a load script to avoid doing it in a dimension. So I would like to take the following and where it meets the following then add FTE.FTEYearEnd2011 to FTEYearEnd2011CurrentView.

Something like the following but I get erros in the script load. Can someone give me the proper syntax. I appreciate any assistance in advance.

([EmployeeDirectory.Team]={'OBG','MFM','GST','ORE','PED','PDS'}, FTE.FTEYearEnd2011,0) as FTEYearEnd2011CurrentView,

Re: If condition in a load script

somenathroy — Wed, 08 Aug 2012 16:05:53 GMT

You may try the below code:

IF([EmployeeDirectory.Team]='OBG' or

[EmployeeDirectory.Team]='MFM' or

[EmployeeDirectory.Team]='GST' or

[EmployeeDirectory.Team]='ORE' or

[EmployeeDirectory.Team]='PED' or

[EmployeeDirectory.Team]='PDS', FTE.FTEYearEnd2011,0) asFTEYearEnd2011CurrentView,

Regards,

Som

Re: If condition in a load script

jonathandienst — Wed, 08 Aug 2012 18:02:07 GMT

I suggest this:


If(Match(EmployeeDirectory.Team, 'OBG','MFM','GST','ORE','PED','PDS'), 
     FTE.FTEYearEnd2011, 0) As FTEYearEnd2011CurrentView

Hope that helps

Jonathan