Hello,
I am trying to display the below table in Qlik sense. What I would like to do is be able to show all accounts and cities that a sales rep is associated with.
For example I would like to be able to select Tom, and see a list of all "Customer Names" and City" that he works with (Note: a 1 under his name means he works with the city and state for that row. For example Tom works with every account and city other then McDonalds or Des moines).
I was originally thinking to do it in 1 pivot table but now think it might just be better to show in multiple visuilizations that are all associated together.
|--------SALES REPS----------|
| Customer Name | City | State | Tom | Dick | Harry | Dwight |
| McDonalds | DES MOINES | IA | 0 | 1 | 0 | 1 |
| Burger King | TAMPA | FL | 1 | 1 | 0 | 1 |
| Wendys | ROSEDALE | MD | 1 | 1 | 0 | 1 |
| Subway | DECATUR | IL | 1 | 1 | 0 | 1 |
| Chipotle | SAUQUOIT | NY | 1 | 1 | 0 | 1 |
| Potbellys | GRANDVILLE | MI | 1 | 1 | 0 | 0 |
| Jimmy Johns | NEEDHAM HEIGHTS | MA | 1 | 0 | 0 | 0 |
| Chilis | PHILADELPHIA | PA | 1 | 1 | 0 | 0 |
| Applebees | MOLINE | IL | 1 | 1 | 1 | 0 |
| Arbys | PORTLAND | OR | 1 | 1 | 1 | 0 |
| Chickfila | ORLANDO | FL | 1 | 0 | 0 | 0 |
| Shake shack | SACRAMENTO | CA | 1 | 1 | 1 | 0 |
| Panda Express | GRAY | ME | 1 | 1 | 1 | 0 |
I would like the result to be something like this:
| Header 1 | Header 2 | Header 3 |
|---|
| | |
| Tom | McDonalds | DES MOINES |
| Tom | Burger King | TAMPA |
| Tom | Wendys | ROSEDALE |
| Tom | Subway | Decatur |
| Tom | Chipotle | SAUQUOIT |
| Harry | Applebees | MOLINE |
| Harry | Arbys | PORTLAND |
Please let me know some suggestions or if you need me to clarify.
