Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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).

geminihzh
Specialist
Specialist

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?

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.