Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
traceyamcb
Contributor II
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

Labels (4)
2 Replies
imark
Contributor III
Contributor III

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
Contributor II
Contributor II
Author

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