how to find top2 voilation in working flag

[#1]

hi,qlikers

i attached some sample data in that i need to find top2 violation employees

how can i find this

Thanks in advanse

Regards

Hemesh

[sunny_talwar]

Are you trying to do this in the script or UI of the application?

[MK_QSL]

You have to use Rank Function !

[sunny_talwar]

May be something like this in the script:

Table:

LOAD [Employee id],

    Date,

    [Employee Name],

    WorkingFlag,

    Duration

FROM

EmployeeDatails.xlsx

(ooxml, embedded labels, table is Sheet1);

Temp:

LOAD [Employee id],

  Count(WorkingFlag) as Count

Resident Table

Where WorkingFlag = 'Voilation'

Group By [Employee id];

Join(Table)

LOAD [Employee id],

  Count,

  AutoNumber(Count) as Rank

Resident Temp

Order By Count desc;

DROP Table Temp;

Output in straight table:

[#5]

in ui i want to find and here the fields are from different tables  Employee id,name are from employee table date is from master calendar and duration,workingflag are from final table

[PradeepReddy · Accepted solution]

Try this...

=Concat(if(aggr(rank(count({<WorkingFlag={'Voilation'}>}[Employee id])),[Employee id])<=2,[Employee Name]),'|')