Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
client1, insurance, active, broker1
client1, medical, unassigned, null
client1, investments, active, broker2
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?
Andre
Hi Andre,
Am sorry but i couldn't understand what is requirement to show on Bar Charts?
Please attach your Qlikview file to understand and find the solution lot easier
Regards
Sunil
This was doen through adding code eventually