Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner
Partner

Could you attach the qvw?

Contributor II
Contributor II

I can't, sorry

Champion III
Champion III

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

Creator III
Creator III

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