topic Unique employees per year next to multiple dimensions in QlikView

Unique employees per year next to multiple dimensions

janwillem — Thu, 08 Feb 2018 14:07:42 GMT

Hi,

At the moment I am working on a graph that shows the percentage of employees that leave our company per age group.

When I calculate the number of unique employees per year to show the percentage only one age group appears in the graph.

I made a table to see what happens. When I use the expression count({<EmployeeNumber= {"*"}-{0}, AgeGroup=,WorkingYears=>} DISTINCT EmployeeNumber) only one age group has the number of unique employees.

Which expression do I need to use to see the number of unique employees at every age group?

Thanks in advance!

Jan Willem Tiemessen

Re: Unique employees per year next to multiple dimensions

sunny_talwar — Thu, 08 Feb 2018 17:21:32 GMT

Are you using an Aggr() function somewhere

Re: Unique employees per year next to multiple dimensions

neelamsaroha157 — Thu, 08 Feb 2018 17:49:14 GMT

If you are using Aggr() function then use NODISTINCT with it.

like Aggr(NODISTINCT Count(Distinct EmployeeNumber), Year).

You can add your set expression to it as needed.

Re: Unique employees per year next to multiple dimensions

janwillem — Fri, 09 Feb 2018 07:20:01 GMT

NODISTINCT is the solution! Thanks!