Qlikview chart problem

[sayanpwc]

Hello friends,

Need a help. Supose I have a dataset with vendorname and spend.

I want a bar chart that will depict 80 % sales comes from how many no of vendors i,e count of vendors and rest coming from how many vendors.

like in the pic. top 80 % spend comes from 204 vendors and rest from 81203.

How to do that?

Please help.

[sunny_talwar]

Check here

Recipe for a Pareto Analysis – Revisited

[sayanpwc]

But sorted aggregation works on Qlikview 12 onwards. I need it to work in qlikview 11. how to do this?

[sunny_talwar]

It would be extremely difficult, if not impossible to do this.... look at this thread which started as a QV11 thread... but then the response market as correct was a QV12 based response... but you can look at ideas for how to do it in QV11 by reading through the thread

ABC Analysis in Qlikview