topic Re: Create a calculated field in a table from other fields in QlikView

Create a calculated field in a table from other fields

adurgani — Wed, 25 Nov 2020 16:16:04 GMT

LOAD

[Cost Center],

if([Cost Center]='0506','IT Planning and Compliance',[Cost Center Description]) as CCDESC,

[Cost Center] &'-'& CCDESC as Group

.....

The error I get is

"Field not found - <CCDESC>"

boorgura — Mon, 09 Apr 2018 17:46:03 GMT

You cannot use CCDESC in the same load.

Either you will have to do a preload.

OR use this:

if([Cost Center]='0506','IT Planning and Compliance',[Cost Center Description]) as CCDESC,

[Cost Center] &'-'& [Cost Center]='0506','IT Planning and Compliance',[Cost Center Description]) as Group

vishsaggi — Mon, 09 Apr 2018 17:49:52 GMT

Or use a preceding load like

TableName:

LOAD *,

[Cost Center] &'-'& CCDESC as Group;

LOAD

[Cost Center],

if([Cost Center]='0506','IT Planning and Compliance',[Cost Center Description]) as CCDESC

......;