Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
axnvazquez
Contributor II
Contributor II

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
Partner

Could you attach the qvw?

axnvazquez
Contributor II
Contributor II
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.