topic Re: Creating new field in QlikView

Creating new field

Anonymous — Wed, 15 Jul 2015 14:09:33 GMT

Hi all,

I'm having trouble creating a new field in the script my see below,

Load

UNIT.GRADEFIX,

if( UNIT.GRADEFIX = '', 2,UNIT.GRADEFIX) as UNIT.GRADEFIX_SCORE,

num(UNIT.M_MILEAGE / 1000) + UNIT.AGEMONTHS + (UNIT.GRADEFIX_SCORE*10) + (UNIT.CAPCLEAN_ORIG /1000) as Unit.GCT_Score

FROM

[$(QVD_Path)\BUYER_unit.qvd]

(qvd);

Does anyone have any idea why I'm getting the error cannot find field?

Thanks

Re: Creating new field

Anonymous — Wed, 15 Jul 2015 14:11:35 GMT

I think that you'd have to share the QVD in order to answer this.

Make sure that field names match exactly...names are case sensitive in QlikView.

Re: Creating new field

awhitfield — Thu, 16 Jul 2015 09:40:17 GMT

Hi Gareth,

you really need to upload your QVD file.

Andy

Re: Creating new field

qlikmsg4u — Thu, 16 Jul 2015 09:47:10 GMT

HI Gareth,

You missing here

Load

UNIT.GRADEFIX,

if( UNIT.GRADEFIX = '', 2,UNIT.GRADEFIX) as UNIT.GRADEFIX_SCORE,

num(UNIT.M_MILEAGE / 1000) + UNIT.AGEMONTHS + (UNIT.GRADEFIX_SCORE*10) + (UNIT.CAPCLEAN_ORIG /1000) as Unit.GCT_Score

FROM

[$(QVD_Path)\BUYER_unit.qvd]

(qvd);

because you don't have that field in QVD but you just created it in your script, so to calculate Unit.GCT_Score you need to resident the above table

Re: Creating new field

Thu, 16 Jul 2015 10:05:08 GMT

Instead of Resident load, you may use the expression again as below

Load

UNIT.GRADEFIX,

if( UNIT.GRADEFIX = '', 2,UNIT.GRADEFIX) as UNIT.GRADEFIX_SCORE,

num(UNIT.M_MILEAGE / 1000) + UNIT.AGEMONTHS + (if( UNIT.GRADEFIX = '', 2,UNIT.GRADEFIX)*10) + (UNIT.CAPCLEAN_ORIG /1000) as Unit.GCT_Score

FROM

[$(QVD_Path)\BUYER_unit.qvd]

(qvd);

or Load on Load as below

Load

num(UNIT.M_MILEAGE / 1000) + UNIT.AGEMONTHS + (UNIT.GRADEFIX_SCORE*10) + (UNIT.CAPCLEAN_ORIG /1000) as Unit.GCT_Score;

Load

UNIT.GRADEFIX,

if( UNIT.GRADEFIX = '', 2,UNIT.GRADEFIX) as UNIT.GRADEFIX_SCORE

FROM

[$(QVD_Path)\BUYER_unit.qvd]

(qvd);

Regards,

KKR

Re: Creating new field

Thu, 16 Jul 2015 10:16:11 GMT

Hi,

You can't create a field and use that field in same load, either you will have to go with resident load or preceding load.

UNIT.GRADEFIX_SCORE field is the one which you are creating and using, which is not allowed. In place of using this value again you can use entire condition there itself.

Regards,

Navdeep

Re: Creating new field

sasiparupudi1 — Thu, 16 Jul 2015 10:17:04 GMT

It is not possible to refer to an expression field in another expression.

replace UNIT.GRADEFIX_SCORE with if( UNIT.GRADEFIX = '', 2,UNIT.GRADEFIX)

Re: Creating new field

Anonymous — Thu, 16 Jul 2015 10:26:14 GMT

Thanks everyone, this has been solved now