employee performance

[AtheerYahyaH]

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]

Hi @AtheerYahyaH 

Try like below

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

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

[AtheerYahyaH]

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]

Hi @AtheerYahyaH 

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])

or

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