topic Re: Creating benchmark based on particular user score in QlikView

Creating benchmark based on particular user score

Wed, 25 Nov 2020 16:16:04 GMT

Hi Everyone,

I want to know how do I create benchmark based on one particular user score.

Here is the scenario.

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.

Re: Creating benchmark based on particular user score

el_aprendiz111 — Tue, 27 Sep 2016 22:40:49 GMT

Hi,

Re: Creating benchmark based on particular user score

Tue, 27 Sep 2016 23:54:43 GMT

@fer fer

Thank you, but I am asking about how do I get that value from the table data (as 0.73 is for this case only, in the future, the value is differ from case to case).

Re: Creating benchmark based on particular user score

Anonymous — Thu, 29 Sep 2016 09:03:31 GMT

Hi,

As fer fer's reply, in the small window "Reference Line", there is the "Expression", you can use the expression to define the formula to get the benchmark as you want. Now the question is, what is the expression?

Zhihong

Re: Creating benchmark based on particular user score

Anil_Babu_Samineni — Thu, 29 Sep 2016 09:13:47 GMT

Have you tried anyway, if yes please post that expression or can you please tell is how do you get that number. Is there Any BRD?

Re: Creating benchmark based on particular user score

Fri, 30 Sep 2016 19:18:14 GMT

I didn't try as of now, but I am thinking like, I can get those values (benchmark values) and the respective faculty name in separate entity and , simply I can provide column as the expression. I don't know how much it works.