Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
greg_buron
Contributor
Contributor

How to show sales reps for each city/account

  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 NameCityStateTomDickHarryDwight
McDonaldsDES MOINESIA0101
Burger KingTAMPAFL1101
WendysROSEDALEMD1101
SubwayDECATURIL1101
ChipotleSAUQUOITNY1101
PotbellysGRANDVILLEMI1100
Jimmy JohnsNEEDHAM HEIGHTSMA1000
ChilisPHILADELPHIAPA1100
ApplebeesMOLINEIL1110
ArbysPORTLANDOR1110
ChickfilaORLANDOFL1000
Shake shackSACRAMENTOCA1110
Panda ExpressGRAYME1110

I would like the result to be something like this:

Header 1Header 2Header 3
TomMcDonaldsDES MOINES
TomBurger KingTAMPA
TomWendysROSEDALE
TomSubwayDecatur
TomChipotleSAUQUOIT
HarryApplebees MOLINE
HarryArbysPORTLAND

Please let me know some suggestions or if you need me to clarify.

0 Replies