Anyway I tried doing it in Qlikview via the ValueList function. I have attached the QVW file which I have been able to make work one bar. However I need this solution to work for multiple bars side by side.
I have a 2nd expression in the bar chart which when enabled I thought would give me the dual bars side by side but it does not do this. If you have a look at the file you will see the behaviour when you enable and un-enable the 2nd expression.
Also, please note that I have not made the expression work for all of the values in the value list but I have done it for 4 of the ones that have the largest values.