Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Requirement on Createing fields

Hi

how to create new fields which are not present in Database and also which are not a calculated  fields

For example:

i have table in that i have 5 fields in that i need to add few new fields

Table1:

A,

B,

C,

D,

E,

F

but now i need to add X,Y,Z which are not Present in Database not a calculated fields

expected output Should be like this

Table1:

A,

B,

C,

X,

D,

E,

Y,

F,

Z,

please help me on this requirements

Thanks

7 Replies
ziadm
Specialist
Specialist

Hi

Load * from Table1;

Concatenate

Load * Inline [

X,Y,Z ];

Not applicable
Author

hi

i have implemented some cross table for that table.now i need to add new fields to it

the above example i have already  tried .

Not applicable
Author

please find my Sample application

in this field section

i need to add 5.1 sample

5.2 sample

e.t.c

Note: These fields are not in Data Base

satishkurra
Specialist II
Specialist II

Ziad approach using concatenate and same table Name should work

ziadm
Specialist
Specialist

Adding new field  works only by joining tables using join or concatenate.  Creating new fields on the fly does not work

are you adding new field or data to the field value

please share your excel data file

satishkurra
Specialist II
Specialist II

Add the below lines of code to get 5.1,5.2 ....

'[5.1 Sample]' as "5.1 Sample"

Not applicable
Author

i did concatenate the added values are showing in listbox but not in Straight Table(i applied cross table here)