topic Help need on difficult query in QlikView https://community.qlik.com/t5/QlikView/Help-need-on-difficult-query/m-p/242130#M92498 <HTML><HEAD></HEAD><BODY><P> This was doen through adding code eventually</P></BODY></HTML> Wed, 23 May 2012 06:08:55 GMT 2012-05-23T06:08:55Z Help need on difficult query https://community.qlik.com/t5/QlikView/Help-need-on-difficult-query/m-p/242128#M92496 <HTML><HEAD></HEAD><BODY><P>HiI really need help with a query I need to create. The data I have currently has an clientid, a service to which he in linked, either with an unassigned value or an active value, and then the current broker , example</P><P>client1, insurance, active, broker1</P><P>client1, medical, unassigned, null</P><P>client1, investments, active, broker2</P><P></P><P>We are bring this through on a bar chart, the issue now is that where the 3rd column is unassigned, we want to show all possible brokers linked to a client, ie have broker1 and broker2 showing on a bar chart as possible brokers for the unassigned service. What is the best way to do this?</P><P></P><P>Andre</P></BODY></HTML> Mon, 22 Nov 2010 12:17:49 GMT https://community.qlik.com/t5/QlikView/Help-need-on-difficult-query/m-p/242128#M92496 2010-11-22T12:17:49Z Help need on difficult query https://community.qlik.com/t5/QlikView/Help-need-on-difficult-query/m-p/242129#M92497 <HTML><HEAD></HEAD><BODY><P>Hi Andre,</P><P>Am sorry but i couldn't understand what is requirement to show on Bar Charts?</P><P>Please attach your Qlikview file to understand and find the solution lot easier</P><P>Regards</P><P>Sunil</P></BODY></HTML> Tue, 23 Nov 2010 08:39:22 GMT https://community.qlik.com/t5/QlikView/Help-need-on-difficult-query/m-p/242129#M92497 2010-11-23T08:39:22Z Help need on difficult query https://community.qlik.com/t5/QlikView/Help-need-on-difficult-query/m-p/242130#M92498 <HTML><HEAD></HEAD><BODY><P> This was doen through adding code eventually</P></BODY></HTML> Wed, 23 May 2012 06:08:55 GMT https://community.qlik.com/t5/QlikView/Help-need-on-difficult-query/m-p/242130#M92498 2012-05-23T06:08:55Z