topic Re: not repeating employee no in QlikView

not repeating employee no

narender123 — Fri, 06 Feb 2015 05:58:20 GMT

Hi all,

I want to count :

like if a employee no (10) entered in jan then our count is 1.

Same employee no (10) entered in feb then the count remains 1.

If a employee no (11) present in feb but not in jan then count in feb 2 means 1 for jan(employee no 10 ) + 1 for feb (employee no 11 ) --------up to dec .

So a employee count remains same if he is repeating in more than 1 month.

I want this result in monthly basis.

Month employee count

jan 1

feb 2

march 7

dec 68

I used: count({<employee_status='p'>}distinct employee_no)

its showing wrong result as distinct work as monthly basis distinction for employee no but i want to check distinct yearly of employee no for monthly dimention.

Thanks

Re: not repeating employee no

Fri, 06 Feb 2015 06:04:06 GMT

Can u paste your app?

Re: not repeating employee no

narender123 — Fri, 06 Feb 2015 06:07:16 GMT

No i am working directly on server.

Its not possible.

Do u have any idea to sort out this?

Thanks,

Re: not repeating employee no

avinashelite — Fri, 06 Feb 2015 06:32:07 GMT

try like this:

Aggr(count({<employee_status='p'>}distinct employee_no),Month)

Re: not repeating employee no

narender123 — Fri, 06 Feb 2015 06:49:39 GMT

Hi Avinash,

Its already giving distinct against month .but i want distinct against year but showing monthwise dimention.

Thanks

Re: not repeating employee no

avinashelite — Fri, 06 Feb 2015 07:02:05 GMT

then you need to have Year as the dimension as well otherwise it won't give correct result and it will be contradictory

too. Add Year as the dimension and try like this

Aggr(count({<employee_status='p'>}distinct employee_no),Month,Year)

Re: not repeating employee no

vikasmahajan — Sat, 07 Feb 2015 05:32:41 GMT

pfa

vikas