topic Re: Calculated column in resident in QlikView

Calculated column in resident

axnvazquez — Mon, 03 Jul 2017 16:42:41 GMT

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 !!

cristianozilz — Mon, 03 Jul 2017 16:46:59 GMT

Could you attach the qvw?

axnvazquez — Mon, 03 Jul 2017 16:47:45 GMT

I can't, sorry

vishsaggi — Mon, 03 Jul 2017 16:54:19 GMT

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

chinnuchinni — Fri, 14 Jul 2017 11:42:18 GMT

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