topic Re: Primary Y Reference Lines in QlikView

Primary Y Reference Lines

traceyamcb — Sat, 16 Nov 2024 21:05:19 GMT

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:

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

Re: Primary Y Reference Lines

imark — Wed, 10 Apr 2019 10:28:07 GMT

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

Re: Primary Y Reference Lines

traceyamcb — Mon, 15 Apr 2019 10:13:18 GMT

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