Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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];
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];
Thanks:) So I added resident Table, but now it says "Table not found TempTable: ...."
Can you share the complete script you are using?
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];