Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
raju_salmon
Creator II
Creator II

Reference line in bat chart

I have a bar chat with dimension date and expression

Sum(Calls)/Count(Calls)*100 - Which shows the calls attended percentage for the day.

I want to show a reference line 95% for Y-Axis. However i cannot able to write exact expression for reference line in presentation tab.

Can anyone help.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

A 95% reference line should be just

=0.95

if you are using numeric representation as percentage, or, since you multiplied by 100,

=95

Are you looking for something else? I must admit I haven't fully understood your percentage calculcation

=Sum(Calls) / Count(Calls)

What is Calls field? Showing duration of single calls?

Could you upload a small sample QVW?

View solution in original post

2 Replies
swuehl
MVP
MVP

A 95% reference line should be just

=0.95

if you are using numeric representation as percentage, or, since you multiplied by 100,

=95

Are you looking for something else? I must admit I haven't fully understood your percentage calculcation

=Sum(Calls) / Count(Calls)

What is Calls field? Showing duration of single calls?

Could you upload a small sample QVW?

Mark_Little
Luminary
Luminary

Hi,

Normally you would just need to add a reference line for .95

Mark