topic how to find top2 voilation in working flag in QlikView

how to find top2 voilation in working flag

Mon, 26 Oct 2015 13:46:44 GMT

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

Re: how to find top2 voilation in working flag

sunny_talwar — Mon, 26 Oct 2015 13:50:18 GMT

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

Re: how to find top2 voilation in working flag

MK_QSL — Mon, 26 Oct 2015 13:53:09 GMT

You have to use Rank Function !

Re: how to find top2 voilation in working flag

sunny_talwar — Mon, 26 Oct 2015 14:04:22 GMT

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:

Re: how to find top2 voilation in working flag

Tue, 27 Oct 2015 04:41:54 GMT

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

Re: how to find top2 voilation in working flag

PradeepReddy — Tue, 27 Oct 2015 05:33:38 GMT

Try this...

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