Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
kulwantsaj219
Contributor II

Groupby

Hi All,

i want to group by the below inline table on 'wo' column.

input:

load * inline [

id, wo, value

1,a,11

1,b,22

2,a,33

2,b,44

];

output

id,value

1,33

2,77

1 Solution

Accepted Solutions

Re: Groupby

This?

input:

load * inline [

id, wo, value

1,a,11

1,b,22

2,a,33

2,b,44

];

NoConcatenate

final:

LOAD id, sum(value) as value Resident input Group By id;

DROP Table input;

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

4 Replies

Re: Groupby

This?

input:

load * inline [

id, wo, value

1,a,11

1,b,22

2,a,33

2,b,44

];

NoConcatenate

final:

LOAD id, sum(value) as value Resident input Group By id;

DROP Table input;

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

Partner
Partner

Re: Groupby

Dear Kulwant,

Please Find below Code:

input:

load * inline [

id, wo, value

1,a,11

1,b,22

2,a,33

2,b,44

];

DATA:

Load id ,Sum(value) As FinalValue Resident input Group By id;

thanks,

Arvind Patil

Re: Groupby

if you want tp do it on front end

Create the straight table on front end

Dimension:

ID

Expression:

Sum(Value)

Highlighted
momin_tahemas
Contributor

Re: Groupby

Table1:

load * inline [

id, wo, value

1,a,11

1,b,22

2,a,33

2,b,44

];

NoConcatenate

Table2:

LOAD id,

sum(value) as value

Resident Table1

Group By id;

DROP Table Table1;

OP

id value
133
277

Regards

Tahemas