topic Re: Stacked graph with counted reference line in QlikView

Stacked graph with counted reference line

matthewp — Tue, 15 Mar 2016 11:39:44 GMT

I am trying to re create this graph but cannot get the reference line to work.

I want spend up the y axis (expression: SUM(spend)), then across the x axis i want supplier name and it stacked by supplier group.

Now the difficult part, i want to have a variable which can be set from a slider between 1 to 100 (not difficult) which will be used in an x axis reference line that splits it by count([supplier name]) and the reference line text shows what percentage of the spend is in that percentage of suppliers.

For example the example below the variable is set to 20, so i want the reference line to be set on the x axis to 20% of the total suppliers used and then the reference line text is calculated that 20% of the suppliers = 80% of the spend.

Re: Stacked graph with counted reference line

Gysbert_Wassenaar — Tue, 15 Mar 2016 11:42:24 GMT

Perhaps this blog post helps: Recipe for an ABC Analysis

Re: Stacked graph with counted reference line

matthewp — Tue, 15 Mar 2016 12:37:15 GMT

tried these and cant get them to work in graph

Re: Stacked graph with counted reference line

matthewp — Tue, 15 Mar 2016 13:32:15 GMT

anyone?

Re: Stacked graph with counted reference line

MarcoWedel — Wed, 16 Mar 2016 00:02:31 GMT

maybe helpful:

In a chart - can I show "today"?

regards

Marco