Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
traceyamcb
New Contributor II

Primary Y Reference Lines

I'm fairly new to Qlikview.

I current have a line chart with Primary Y reference lines. However, these lines are created from an inline load script, i now want to improve my chart by having the reference line created from within the chart. 

We have a business target, which isn't currently derived from existing data.

My load script looks like, for example:

Load * Inline [

Date_ID, Raised, Closed

01/03/2018, 74, 90

08/03/2018, 74, 90

15/03/2018, 74, 90

01/03/2019, 84, 100

08/03/2019, 84, 100

15/03/2019, 84, 100

];

This gives me the desired effect of:

Capture.JPG

The question is, how do i achieve the same effect, using the Primary Y reference lines within the presentation tab in Qlikview?

Many thanks in advance 🙂

Tracey

2 Replies
imark
New Contributor II

Re: Primary Y Reference Lines

Hi Tracey,

IF(Date_ID >= 'yyyy-mm-dd', 74, 84)

should work. And you could even have it among the expressions.

If the targets are highly volatile however, and to the best of my knowledge, this can become tedious as you would need to have lots of IFs within one another.

EDIT: actually, it seems to be only working if used in the expression tab. But then again, you can customise it there to look exactly as a reference line from the presentation tab.

-Igor

traceyamcb
New Contributor II

Re: Primary Y Reference Lines

Thank you for your reply.

It appears it's not possible to have 2 references lines of differing points. whilst also using a multiple date ranges,

I have therefore simplified my report by having a rolling year graph instead 🙂

Thank you for your response.

 

Tracey