topic Re: How to write calculated field in the script in QlikView

How to write calculated field in the script

Sat, 10 May 2014 15:55:29 GMT

Hello

Help me to write calculated field in the script, please:

COUNT(TOTAL <Field1> DISTINCT Field2) as Field3,

it's works in the pivot table, but don't works in script.

its_anandrjs — Sat, 10 May 2014 15:59:38 GMT

In load script you have to aggregate the count with dimensions.

See the example for this

Source:

Load

Field1,

Field2,

Field3

From Locaition;

Final:

Load

Field1,

Field2,

Count(Field3) as Field3

Resident Source

Group by Field1,Field2;

Drop table Source;

Joseph_Musekura — Sat, 10 May 2014 16:31:05 GMT

See attached sample with 2 alternatives.

Thanks