Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating benchmark based on particular user score

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.

5 Replies
el_aprendiz111
Specialist
Specialist

Hi,

Reference.png

Not applicable
Author

@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).

Anonymous
Not applicable
Author

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

Anil_Babu_Samineni

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?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable
Author

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.