topic Re: Reference line in bat chart in QlikView

Reference line in bat chart

raju_salmon — Thu, 26 Nov 2015 11:39:01 GMT

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.

swuehl — Thu, 26 Nov 2015 11:43:20 GMT

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 — Thu, 26 Nov 2015 11:44:48 GMT

Hi,

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

Mark