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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
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