topic Aggregate Multiple fields in QlikView

Aggregate Multiple fields

Tue, 18 Nov 2014 12:50:26 GMT

hi all

i need help with aggregation

i aggregate data

LOAD

F1,F2

,count(Id)

from fileSource

GRoup By

,F2

;

however this doesn't display satisfied results. What is wrong with my script can someone tell me pls?

marcus_malinow — Tue, 18 Nov 2014 12:52:59 GMT

If you're getting an inflated figure it may be that you need to do count(distinct Id).

Otherwise, can you post a sample of your data and the expected results?

maksim_senin — Tue, 18 Nov 2014 13:10:16 GMT

It's better to provide (a) source data and/or (b) working/runnable qv-script.

Neither (a) nor (b) I can see here, so it's hard to advice.

Please find working example, hope this will help somehow:

// BEGIN

fileSource:

load * Inline

[

id,F1,F2

1,1,1

2,1,2

3,2,1

4,2,2

5,1,2

6,2,2

];

LOAD

F1,F2,count(id)

Resident fileSource

GRoup By F1,F2;

drop Table fileSource;

// THE END

Best regards,

Maxim

maleksafa — Tue, 18 Nov 2014 13:36:57 GMT

can you upload a sample document and tell us what is the desired outcome, maybe you need to use distinct instead of count().