topic Script edit need to use an AS field as input in the script. in QlikView

Script edit need to use an AS field as input in the script.

Mon, 30 Jul 2012 16:54:19 GMT

Based on the setting for SalesOffice then I would like to set the name of the SalesOffice.

My Code isn't working. What do I have to do to use SalesOffice as input?

if([Order Source] = 'FL','FL' ,

if([Order Source] = 'MW','MW' ,

if([Order Source] = 'WC', 'WC' ,

if([Order Source] = 'NE','NE' ,

if([Order Source] = 'JS','JS' ,

if([Order Source] = 'OS','OS' ,

if([Order Source] = 'BN','BN' ,

if([Order Source] = 'NT','NT' ,

if([Order Source] = 'SG','SG' ,

if([Order Source] = 'JE','JS', [Customer GL Code])))))))))) as SalesOffice ,

if( SalesOffice = 'FL','Florida-Export' ,

if(SalesOffice = 'MW','Midwest' ,

if(SalesOffice = 'WC', 'West Coast' ,

if(SalesOffice = 'NE','Northest' ,

if(SalesOffice = 'JS','Jerrys Sports Center' ,

if(SalesOffice = 'OS','Outdoor Sports' ,

if(SalesOffice = 'BN','Bonitz' ,

if(SalesOffice = 'NT','Jerrys Northeast' ,

if(SalesOffice = 'SG','Simmons Guns' ,

if(SalesOffice = 'HS','Chapin Hunting' ,

if(SalesOffice = 'MA','Chapin Marine' , 'Invalid Office'))))))))))) as SalesOfficeName ,

Re: Script edit need to use an AS field as input in the script.

cesaraccardi — Mon, 30 Jul 2012 17:18:14 GMT

Hi,

Whats the message you are getting after reload?

Re: Script edit need to use an AS field as input in the script.

swuehl — Mon, 30 Jul 2012 17:27:37 GMT

You can't reference the output table field SalesOffice in the same load context where you create it, i.e. SalesOffice field is not known as input table field in the SalesOfficeName conditional.

You can use a preceding load to get around this:

LOAD SalesOffice,

if( SalesOffice = 'FL','Florida-Export' ,

if(SalesOffice = 'MW','Midwest' ,

if(SalesOffice = 'WC', 'West Coast' ,

if(SalesOffice = 'NE','Northest' ,

if(SalesOffice = 'JS','Jerrys Sports Center' ,

if(SalesOffice = 'OS','Outdoor Sports' ,

if(SalesOffice = 'BN','Bonitz' ,

if(SalesOffice = 'NT','Jerrys Northeast' ,

if(SalesOffice = 'SG','Simmons Guns' ,

if(SalesOffice = 'HS','Chapin Hunting' ,

if(SalesOffice = 'MA','Chapin Marine' , 'Invalid Office'))))))))))) as SalesOfficeName;

LOAD

if([Order Source] = 'FL','FL' ,

if([Order Source] = 'MW','MW' ,

if([Order Source] = 'WC', 'WC' ,

if([Order Source] = 'NE','NE' ,

if([Order Source] = 'JS','JS' ,

if([Order Source] = 'OS','OS' ,

if([Order Source] = 'BN','BN' ,

if([Order Source] = 'NT','NT' ,

if([Order Source] = 'SG','SG' ,

if([Order Source] = 'JE','JS', [Customer GL Code])))))))))) as SalesOffice

FROM YOURSOURCE;

You can also check the mapping functions in QV, this could be of interest for your name mappings.

Hope this helps,

Stefan