Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try like below
Count({<[assignee full name] = {'Atheer'}>}Distinct TicketNo)
-- it gives no. of tickets assigned to 'Atheer'
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.
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])