topic Re: Reference Line in QlikView

Reference Line

bobbydave — Fri, 20 Nov 2020 18:02:30 GMT

I am trying to create a reference line showing a stacked bar chart with expressions 'Cycle Hit' and 'Cycle Miss'

I want to differentiate between them with a reference line.

Analyst would be my dimension.

So I am saying in my Target reference expression

if( Analyst = 'A', 1,

if( Analyst = 'B', 1,

if( Analyst = 'C', 1,

if(Analyst = 'D', 1,

if(Analyst = 'E', 4,

if( Analyst = 'F', 4 )))))))

So what will happen is the Analysts will all have the reference link showing as 1 but will spike to 4 on E and F

Any ideas as my IF Target statement doesnt work

Re: Reference Line

stigchel — Fri, 29 May 2015 10:31:39 GMT

A reference line (in presentation tab) is not evaluated by the chart's dimensions. You can use a combo chart where you add this expression with line representation in the expression tab

Re: Reference Line

stigchel — Tue, 02 Jun 2015 14:50:21 GMT

Has this helped, or do you have any further questions?

Re: Reference Line

bobbydave — Wed, 03 Jun 2015 10:29:01 GMT

Combo chart was the way to go.

Thanks