Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is it possible to add/update new columns to an already existing table in Qlik Sense?

HI,

Suppose I have a loaded table with the column INCOME and based on certain filters I want to generate a new column that is, INCOME * 2. Is it possible to do this with Qlik Sense without having to write stored procedures? Basically, I want the results to be generated dynamically. What is the easiest way to work around this using Qlik Sense?

Thanks!

2 Replies
sinanozdemir
Specialist III
Specialist III

Hi,

You can do this in the LOAD script;

LOAD

     INCOME,

     INCOME * 2 As NEW_INCOME;

SQL SELECT

     INCOME,

     Other_Columns

FROM Your_Database;

Hope this helps

Not applicable
Author

I will try it out! Thanks alot!

On Fri, Jun 24, 2016 at 6:43 AM, Sinan Ozdemir <qcwebmaster@qlikview.com>