I have a QlikView dashboard which displays two pivot tables (one for London sales and another for Manchester sales). These pivot tables are placed within a container object so that selecting a pivot table, replaces the one displayed in the container.
I have a list box entitled 'Salesperson' which lists the sales personnel for both London and Manchester. When a pivot table is selected I want the list box to display only those salespersons related to that pivot table (that is, London or Manchester, not both).
How do I script for this ?