topic Replicating Omniscope functionality in QlikView https://community.qlik.com/t5/QlikView/Replicating-Omniscope-functionality/m-p/478983#M1145075 <HTML><HEAD></HEAD><BODY><P>Hi I am looking to do the following in a dashboard</P><P></P><P>I am looking to have two bar charts the first showing sales by customer in a given month for example sorted by highest sales</P><P></P><P>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.</P><P></P><P>I could do this in Omniscope if I remember correctly using the query functionality</P><P></P><P>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.</P><P></P><P>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</P><P></P><P>HELP !!!</P></BODY></HTML> Fri, 09 Aug 2013 00:44:29 GMT 2013-08-09T00:44:29Z Replicating Omniscope functionality https://community.qlik.com/t5/QlikView/Replicating-Omniscope-functionality/m-p/478983#M1145075 <HTML><HEAD></HEAD><BODY><P>Hi I am looking to do the following in a dashboard</P><P></P><P>I am looking to have two bar charts the first showing sales by customer in a given month for example sorted by highest sales</P><P></P><P>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.</P><P></P><P>I could do this in Omniscope if I remember correctly using the query functionality</P><P></P><P>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.</P><P></P><P>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</P><P></P><P>HELP !!!</P></BODY></HTML> Fri, 09 Aug 2013 00:44:29 GMT https://community.qlik.com/t5/QlikView/Replicating-Omniscope-functionality/m-p/478983#M1145075 2013-08-09T00:44:29Z