Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with Expressions please

If I have a table containing data like this:

pic3.png

Please could someone tell me how to write expressions to show:

  • The fewest number of minutes spent by anyone on a Problem Code (please note that every time someone spends time on a call it creates a seperate entry, so I would need to sum the time spent for each call linked to the problem code and show the lowest sum) - looking for a team record.
  • The fewest number of minutes spent by the individual I am looking at on a Problem Code - looking for a personal best.

Thanks.

1 Reply
whiteline
Master II
Master II

Create two charts. One with [Problem Code] dimension the other with [CallRef] (I guess its an individual).

And use this expression (in both charts):

=Min(aggr([Minutes Spent], [Problem Code], [CallRef])