Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Adding an extra value to a feild

Dear All

I am having table contains the two field key and value. I want to add an extra value as C to feild Key.

which can have a value of A+B.

So C can have 30 in the table how can i achieve this??

I/O

KeyValue
A10
B20

O/P

KeyValue
A10
B20
C30

Pls see attachment

Tags (2)
1 Reply
swuehl
Not applicable

Re: Adding an extra value to a feild

Maybe like this?

TABLE:

LOAD * INLINE [

    Key1, Value

    A, 10

    B, 20

];

LOAD 'C' as Key1,

          sum(Value) as Value

Resident TABLE;