Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
axnvazquez
Contributor III
Contributor III

Calculated column in resident

Hi, I need help with doing this

I have this table :

Example:

LOAD

id,

group,

date,

sum(cant) as Cant,

sum(days) as Days

FROM ...

group by id, group, date;

Before this, i have three concatenates which add 3 new values.

and after that, i have to add new columns based in these previous values, so i use "resident"

Load

id,

group,

date,

sum(concatenate_value1) as concat1,

sum(concatenate_value2) as concat2

sum(concatenate_value1 + concatenate_value3) as concat 3

resident example

group by group by id, group, date;


But this isn't working, any idea with this ??


thanks !!

4 Replies
cristianozilz
Partner - Contributor III
Partner - Contributor III

Could you attach the qvw?

axnvazquez
Contributor III
Contributor III
Author

I can't, sorry

vishsaggi
Champion III
Champion III

Can you copy paste your full script here? Including your Concatenate tables script?

chinnuchinni
Creator III
Creator III

if you will provide sample data,we may help you in this surely.