topic Re: Group by in QlikView

Group by

Tue, 14 Jun 2016 01:00:57 GMT

I think this is a simple task but not sure why it's not working.

I want to group by a field (employees' location) and count the number of employees per location, and have them in a separate table.

TempTable:

Load

[employees location],

Count([Employee ID]) as [Number of employees at Location]

Group by

[employees location];

When I load the script, my TempTable is not showing up anywhere, neither the [Number of employees at Location] field. Not sure what's happening?

sunny_talwar — Tue, 14 Jun 2016 01:02:17 GMT

You might have missed the Resident tablename;

TempTable:

Load

[employees location],

Count([Employee ID]) as [Number of employees at Location]

Resident TableName

Group by

[employees location];

Tue, 14 Jun 2016 01:07:09 GMT

Thanks:) So I added resident Table, but now it says "Table not found TempTable: ...."

sunny_talwar — Tue, 14 Jun 2016 01:10:20 GMT

Can you share the complete script you are using?

Anonymous — Tue, 14 Jun 2016 06:47:08 GMT

Hi QlikNewbie,

Are you calculating this table on Section Access?

If the answwer is yes, calculate it on Section Application.

If the answer is no, try

TempTable:

Load

[employees location],

Count(Distinct [Employee ID]) as [Count of Number of employees at Location]

Resident YourTable

Group by

[employees location];