Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

axnvazquez
New 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
New Contributor III

Re: Calculated column in resident

Could you attach the qvw?

axnvazquez
New Contributor II

Re: Calculated column in resident

I can't, sorry

vishsaggi
Esteemed Contributor III

Re: Calculated column in resident

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

chinnuchinni
Contributor III

Re: Calculated column in resident

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