topic Sorting People under Departments in QlikView

Sorting People under Departments

Thu, 19 Dec 2013 10:03:22 GMT

Hi,

I have a graph with a group of sales people that i need sorted under their departments. I have a previous post on this but I now need to take it further so I am opening an new question.

I need the graph to be sorted with the sales/person and then group all the sales people per department. I need both names of person and department showing, and i need to show only the people that actually belong to an department to show up there. I have a pivot table set up and i really just need that table to be shown as a graph.

Cheers,

Re: Sorting People under Departments

Gysbert_Wassenaar — Thu, 19 Dec 2013 10:19:59 GMT

See attached qvw. That's the best that's possible afaik.

Re: Sorting People under Departments

Thu, 19 Dec 2013 10:45:25 GMT

tnx, but i still need to tell the departments apart somehow,preferably with colors. any ideas on that?

Re: Sorting People under Departments

Gysbert_Wassenaar — Thu, 19 Dec 2013 10:48:44 GMT

Create an expression that calculates a coloer per department. Click on the + in front of the expression, select Background Color and enter an expression. For example color(FieldIndex('Department',Department))