Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Min, Max, Current - help with a bar chart

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

1 Reply
Highlighted
MVP
MVP

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