topic Re: creating benchmark graph in QlikView

creating benchmark graph

Wed, 25 Nov 2020 16:16:04 GMT

Dear community,

I have been puzzling like crazy, but I can't find the solution to my problem. Therefore I would like to ask for your help.

I am trying to create a benchmark graph, similar to the one that can be found in the attachment.

In short: It is a bar chart where I would like to compare the value of 1 person to the mean value of the whole group of people. Very simply put. Person A has sold 10 units, Person B has sold 2 units. The mean value of the whole group is 5 units. Therefore Person A has a positive value of +5 and Person B a negative value of -3. I would like to visualize this in a bar chart with positive and negative values.

I someone will be able to explain me how to create such chart.

Thank you very much in advance for your help!

Re: creating benchmark graph

Gysbert_Wassenaar — Tue, 24 May 2016 15:34:43 GMT

Something like this: sum(total units)/count(distinct total person) - sum(units)

Re: creating benchmark graph

ramasaisaksoft — Tue, 24 May 2016 16:52:03 GMT

Hi Gijs,

PFA..

Re: creating benchmark graph

MarcoWedel — Tue, 24 May 2016 20:15:47 GMT

Hi,

one solution might be also:

Sum(Units)-Avg(TOTAL Aggr(Sum(Units),Person))

hope this helps

regards

Marco

Re: creating benchmark graph

Wed, 25 May 2016 08:49:01 GMT

Thank you all so much for your wonderful and fast help!

It worked, thanks to your incredible support!

massive thanks to you all

Re: creating benchmark graph

Mon, 26 Sep 2016 17:35:34 GMT

Hello marcowedel‌

Could you tell the few more steps to do that one,

I just need the below one only.

Thank you.

Re: creating benchmark graph

MarcoWedel — Tue, 27 Sep 2016 18:55:55 GMT

Hi,

hope this helps

regards

Marco

Re: creating benchmark graph

Wed, 28 Sep 2016 00:00:12 GMT

marcowedel‌

Thank you for the information. But mine is some different case, could you help me on this

Scenario (Creating benchmark based on particular user score):

For one particular presentation, the reviewers(including faculty) gave the marks to reviewees (more than one for one particular presentation).

Now I want to create a benchmark (horizontal reference line) for this chart, based on the faculty score only. (i.e a horizontal line at 73% value of y axis)

Could you help me in this case. I am not sure how can I get that faculty score while creating benchmark.

Attached the bar chart and table of data screenshots.

I want to know how do I use the faculty score to draw the bench mark.

Thank you.