topic Re: Requirement on Createing fields in QlikView

Requirement on Createing fields

Wed, 25 Nov 2020 16:16:04 GMT

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:

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:

please help me on this requirements

Thanks

ziadm — Mon, 27 Jun 2016 17:25:50 GMT

Load * from Table1;

Concatenate

Load * Inline [

X,Y,Z ];

Mon, 27 Jun 2016 17:39:25 GMT

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 .

Mon, 27 Jun 2016 17:41:31 GMT

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 — Mon, 27 Jun 2016 17:45:03 GMT

Ziad approach using concatenate and same table Name should work

ziadm — Mon, 27 Jun 2016 17:50:07 GMT

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 — Mon, 27 Jun 2016 17:52:16 GMT

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

'[5.1 Sample]' as "5.1 Sample"

Mon, 27 Jun 2016 18:51:22 GMT

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