Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Cloud Maintenance is scheduled between March 27-30. Visit Qlik Cloud Status page for more details.
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>