Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating new column by adding or subtracting value in other columns

Hi All!!

is it possible to make another column by adding or subtracting other two columns?

for example, let's say by Outer Joining I got three columns col1, col2, col3

Can I make col4 by col1 - col2?

1 Solution

Accepted Solutions
Gysbert_Wassenaar

NewTable:

LOAD

     col1, col2, col1 - col2 as col3

RESIDENT

     OldTable;

DROP TABLE OldTable;



talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

NewTable:

LOAD

     col1, col2, col1 - col2 as col3

RESIDENT

     OldTable;

DROP TABLE OldTable;



talk is cheap, supply exceeds demand

View solution in original post