Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

adding a new value to a field

hello

I'm trying to add two additional values to a field when loading "service as Cost_activity."  the field only has 3 values (A, B, C) for cost_activity.  I want to add in the script "D" and "E" as values which do not currently exisit in the source table.  how do a I add them?
LOAD

id as service_id,
service as cost_activity,


SQL SELECT *
FROM service;
Tags (2)
1 Solution

Accepted Solutions
Highlighted
Champion III
Champion III

adding a new value to a field

Add this script:

CONCATENATE
LOAD * INLINE [
service_id,  cost_activity
'service id for D', D
'service id for E', E
];

View solution in original post

3 Replies
Highlighted
Luminary
Luminary

Re: adding a new value to a field

Try this:

Data:

LOAD
id as service_id,
service as cost_activity,
SQL SELECT *
FROM service;

Concatenate (Data)
Load * Inline [
cost_activity
D
E

];


That should crack it.

All the best,

Matt - Visual Analytics Ltd

Qlikview Design Blog: http://QVDesign.wordpress.com

Highlighted
Champion III
Champion III

adding a new value to a field

Add this script:

CONCATENATE
LOAD * INLINE [
service_id,  cost_activity
'service id for D', D
'service id for E', E
];

View solution in original post

Highlighted
Not applicable

adding a new value to a field

worked like a charm. thanks guys