Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
Honored Contributor II

Re: Help with Expressions please

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

Community Browser