Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

stuhico09
Contributor

Transform current data (2 table is joined)

Dear Team,

xxx.PNG

I already combined two table using join. But now i want to transform my data as below. Please help. Thanks.

xxx1.PNG

a) Create new line item for each task with created status

b) Create new field "Month_Graph." & assign "Task Created" as its date.

1 Solution

Accepted Solutions
xufei123
Valued Contributor

Re: Transform current data (2 table is joined)

When you use sum() or count(), you need to add group by!

Created:

load

    ....

    .... as Total

resident owssvr

group by Temp, month_created, [PSR No];

4 Replies
stuhico09
Contributor

Re: Transform current data (2 table is joined)

I almost done. But i cannot add this expression. Please advise. Thanks.

xxx1.PNG

Error:

xxx.PNG

stalwar1

Do you have any advise? Thanks.

xufei123
Valued Contributor

Re: Transform current data (2 table is joined)

When you use sum() or count(), you need to add group by!

Created:

load

    ....

    .... as Total

resident owssvr

group by Temp, month_created, [PSR No];

Re: Transform current data (2 table is joined)

try like

load temp,

     id_no,

     'created' as status,

     task_created as month_graph

from tablename;

concatenate

load temp,

     id_no,

     status,

     task_modified as month_graph

from tablename;

regards,

Regards,
Prashant Sangle
stuhico09
Contributor

Re: Transform current data (2 table is joined)

Thanks Fei Xu.

Community Browser