Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get correct employee count datewise

Hi All

PFA

here by using below script

Data:

LOAD *,Date(Floor(TimeData)) as Date,

       Time(Frac(TimeData)) as Time  ;

      

LOAD id,

     [Employee id],

     EventID,

     TimeData

FROM

(ooxml, embedded labels, table is Sheet1);

and in text object expression count(employee id) it is giving 30

i want count as 3 here only 3 dates are available

how to get this please reply me

Regards

Hemesh

22 Replies
Not applicable
Author

it is working fine please find the qvw that i attached here while using join with manager details table i am not getting matching records from manager table

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Well,

If you check the field Employee_id That is Concatenated with date also.the Employ Id should change right?.

If you take that Employee_id in tables like Straight Table, Pivot Table and TableBox ,You can see the difference.

Regards,

Nagarjuna

Not applicable
Author

my previous expression is count(employee id) i replaced it  with sum(aggr(count(employee id),employee id ,date))

how can i replaced  the expression of

=Concat(if(aggr(rank(count({<HourFLag={'Violation'}>}[Employee id])),[Employee id])<=3,[Employee id]),Chr(13))