topic Re: employee performance in QlikView

employee performance

AtheerYahyaH — Mon, 18 Jan 2021 06:52:31 GMT

I want to have a dashboard based on employees performance. i want to see each employee how much they closed tickets, opened tickets...etc

the syntax is wrong but this is my logic. i am new to qlik sense 🙂

[assignee full name] = 'Atheer' << i want a table of Atheer's performance .

or something like this.

select Employee where assigneeFullName = 'Atheer'

this is all from edit expression.

MayilVahanan — Mon, 18 Jan 2021 07:43:32 GMT

Try like below

Count({<[assignee full name] = {'Atheer'}>}Distinct TicketNo)

-- it gives no. of tickets assigned to 'Atheer'

AtheerYahyaH — Tue, 19 Jan 2021 06:36:24 GMT

it didnt work, it gives me invalid dimension.

I tried assignee as a dimension and added 3 measures for open, closed & WIP status. but also didnt work.

MayilVahanan — Tue, 19 Jan 2021 07:12:55 GMT

Its measure, not dimension..

[assignee full name] = 'Atheer' << i want a table of Atheer's performance .

<-- For Dim, try like below

If([assignee full name] = 'Atheer' , [assignee full name])

If(Match([assignee full name], 'Atheer', 'Yahya'), [assignee full name])