Discussion board where members can learn more about Qlik Sense App Development and Usage.
I need help creating a visualization showing the count of service reps assigned to each customer as well as being able to show which reps.
I have a table containing one column “customer name” and then several other columns showing service reps related to that client. See below
Service Rep 1 (Tom)
Service rep 2 (Dick)
Service Rep 3 (Harry)
Service Rep 4 (Michael)
Service Rep 5 (Scott)
Service Rep 6 (Dwight)
Ideally would like to select a customer (ex. McDonalds) and be able to see that it has 3 reps and be able to see that they are Tom, Michael, and Scott.
I was thinking to just do a chart and show a yes now but in my actual data i have much more then was
Appreciate any advice on how to display this.
You can use Pivot table. And can you share some sample data to look into?
Did you try with Pivot? Did it work?