topic Re: Groupby in QlikView

Groupby

Anonymous — Wed, 27 Sep 2017 06:54:28 GMT

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

Re: Groupby

Anil_Babu_Samineni — Wed, 27 Sep 2017 07:00:49 GMT

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;

Re: Groupby

arvind_patil — Wed, 27 Sep 2017 07:02:00 GMT

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

Kushal_Chawda — Wed, 27 Sep 2017 07:05:57 GMT

if you want tp do it on front end

Create the straight table on front end

Dimension:

Expression:

Sum(Value)

Re: Groupby

Anonymous — Wed, 27 Sep 2017 07:18:23 GMT

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;

id	value
1	33
2	77

Regards

Tahemas