topic Graph with a cumulative value in QlikView

Graph with a cumulative value

m4u — Sun, 12 Feb 2012 00:17:30 GMT

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

Re: Graph with a cumulative value

swuehl — Sun, 12 Feb 2012 00:40:33 GMT

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.

Re: Graph with a cumulative value

m4u — Sun, 12 Feb 2012 01:17:05 GMT

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.

Re: Graph with a cumulative value

swuehl — Sun, 12 Feb 2012 11:13:15 GMT

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.