Min, Max, Current - help with a bar chart

andyquirin — Fri, 10 Jan 2014 22:07:51 GMT

Hey Qlik'ers,

I need some help with a bar chart and hopefully you guys will know what to do.

I'm making a 'headcount' dashboard used for workforce planning that has 12 months of data in it.

It needs to have a single bar chart that shows Minimum, Maximum, and Current number of tickets closed per employee.

I will need to show this by a few different dimensions (tickets closed per employee by shift, tickets closed per employee by location, etc). Is there a good way to do this without coding out the min/max/current on the SQL side?

Thanks in advance for your help!!

Andy

Re: Min, Max, Current - help with a bar chart

MK_QSL — Fri, 10 Jan 2014 22:13:21 GMT

Create a Cyclic Group for

Ticket Closed Per employee by location

Ticket Closed per employee by shift

and use it as a single dimension for bar chart

Expression

MIN(Aggr(SUM(TICKET),Employee))

MAX(Aggr(SUM(TICKET),Employee))

SUM(Aggr(SUM(TICKET),Employee))

topic Min, Max, Current - help with a bar chart in QlikView

Min, Max, Current - help with a bar chart

Re: Min, Max, Current - help with a bar chart