I have two universe queries
the first gets a list of clients, the second gets a list of count of accounts for that client by load month (for a column chart) using a prompt.
I have a list box that has the Labels set to the first query Clientname
I have set Data Insertion as Label with destination as the prompt in query two. When I change the selected item this does not refresh query two.
I do not have the query triggered on an excel cell as I am trying to avoid making use of the embedded excel at all if possible and merely have the dashboard working directly with universe queries.
How can I get the second query to refresh when the list item is changed?
The only way I can see to do this is to set the List desintation as an excel cell and set query two to trigger on that Trigger Cell when value changes.
If this is the case what is the point of having the list destination as a query prompt?
Am I missing something wonderfully simple and elegant here ?
(I really hope I am as otherwise the prompt destination seems kind of pointless)
Thanks
HuwD 
(BOB member since 2007-04-19)