Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

stefan_fischer
New Contributor II

Additional field in a table with fix value

Hi,

in a QlikView-table i want to have one additional field with constant value. How can i integrate a fixed attribute.

fieldname [Additional field]

value: test

LOAD

month,

structure_name, 

...

[Additional field]

FROM;

Regards

Stefan

1 Solution

Accepted Solutions
salto
Valued Contributor II

Re: Additional field in a table with fix value

PFA the example.

Hope this helps!

5 Replies
salto
Valued Contributor II

Re: Additional field in a table with fix value

Hello,

just add the fieldname in the LOAD:

LOAD

month,

structure_name,

...

'test' as [Additional field]

FROM;

Hope this helps!

Re: Additional field in a table with fix value

Try this

LOAD month,

     structure_name,

     location_name,

     location_class,

     cost_eur,

     largest_case,

     comment,

     ncc_focus,

     data_evalution,

     1000 AS NewField //if it is a string 'String' AS NewField

FROM

D:\Projekte\QlikView\qk01.xlsx

(ooxml, embedded labels);

jpapador
Valued Contributor

Re: Additional field in a table with fix value

In your load script just do

'Test' as [Additional Field]

rustyfishbones
Honored Contributor II

Re: Additional field in a table with fix value

you can add a new field like this. So you will get a field with Value in each

2013-10-18_1448.png

salto
Valued Contributor II

Re: Additional field in a table with fix value

PFA the example.

Hope this helps!

Community Browser