Reference Line in Bar Chart or pivots on calendar data

[QlikSensor]

Hi,

I have a bar chart (from vizlib) and a pivot table which shows monthly data (production months).

Now I have a second table which is joined via another dimension (not the production months). In this table there is stated a date which describes a certain measure introduced to the production. I want to draw a reference line in my bar chart at this production introduction date (or highlight it in the pivot).

In the bar chart I used following equation for the reference line, but this doesn't seem to work. 

=max([Introduction date to production])

Any hints, why or is there a better solution?

[JordyWegman]

Hi,

Should this be a horizontal or vertical reference line?

Jordy

Climber

[QlikSensor]

A vertical line. The vizlib Barchart makes that possible. Saying this, I have a similar problem by coloring the "production date" > "introduction in production date" in Pivot tables.

[JordyWegman]

Yes, did you enter an '=' value before? Qlik's native objects don't need that, but these from Vizlib do. Without it, it won't evaluate your statement.

Jordy

Climber

[QlikSensor]

Hi again,

I used this statement (copy from the original post):

=max([Introduction date to production])

[QlikSensor]

Please note that [Production Date] (used in the bar chart as dimension) and [Introduction date to production] (used as reference line) are different dimensions.

[QlikSensor]

Can this be the problem that they are different dimensions? How can we handle this problem? Both dimensions are classified as dates...

[JordyWegman]

Can you maybe show a sample of your QVF or the data model viewer?

Jordy

Climber