Graph with a cumulative value

[m4u]

Hi freinds,

i need to create a graph like the attached image.

I have a list of stores with their monthly revenue (store_name, store_revenue).

the purpuse of the graph is to show how meany stores are creating how meany percent of the total company revenue.

the x - axis shows the number of stores and the y - shows is the comulative percent (until we get to 100%), that way you can see that 1 store is making 10% of the revenue, and 80 stores are creating

90% of revenue etc.

I would like to know how can do this in qlikview.

Many thanks
Shlomo

[swuehl]

You can use a calculated dimension

=aggr(num(rank(sum(Value),4)),Store)

for the x-axis, sorted by numerical value.

Then use

=sum(Value) / sum(total Value)

as expression, enable show as percentage in number tab.

See also attached.

Regards,

Stefan

[m4u]

Thank you,

Your example is very helpful.   But I was left with one small problem:

Now I get on the x-axis over 200 stores (image attached), how can i make a smaller view as it was in the first picture I attached.

[swuehl]

I think a good possible solution is to use a continuous axis.

Another approach might be to use class() function in the dimension around the aggr() function.

See also attached.