Hi I am looking to do the following in a dashboard
I am looking to have two bar charts the first showing sales by customer in a given month for example sorted by highest sales
The second chart is linked to the first and when a customer is selected in the first it expands to show the sales by month to that customer over the past 6 months.
I could do this in Omniscope if I remember correctly using the query functionality
So far I haven't been able to reproduce in Qlikview as if I select multiple months in the first instance I see the first chart sorted by highest aggregate sales over the period and if I only select one month then whilst the first chart is prioritised correctly I only see one of data in the second chart.
So in summary I am looking for a single month of data in the first chart and multiple months of data in the second with the first chart selecting the customer in the second
