Straight line in chart irrespective of the value

[#1]

Hi,

I have a chart with month on x-axis, there three other metrics in the chart as well, I have attached two screenshot, one is Chart and another one is Chart Expected.

Expected Chart is possible in Excel, but try to achieve in Qlikview. Since the third metric is small values, its appearing very small color in the Chart screenshot.

Is it possible to achieve this in Qlikview to show straight value for third metric.

Thanks,

[giakoum]

try to use reference lines

[joshabbott]

What does the value of the red line's need to be?  You could add another expression and make it a bar (change color to red in the + of the expression) and have it be something like:  if(week = 3 or week = 8 or week = 13, 25000)  Also make sure to use the left axis for this expression.

Hope this helps!

[#4]

I did that, but if any other metrics value increases then it will small BAR on the chart. any best suggestions.

Thanks,

[joshabbott]

How about:

if(week = 3 or week = 8 or week = 13, max(aggr([put your expression for the bars you have here, sum or whatever], [put the dimension of the chart here])) + (the same max as just before the plus sign * .10)

This should give you the max bar of the bar's you have in the expression plus 10% on top of it.  You could play around with the *.10 number to increase or decrease the size

[#6]

Good idea, but assume if I have three metrics which is going over metric. Not sure which one to take in the expression.

Thanks,

[joshabbott]

you could throw an if statement in to see which is larger in that situation.

[#8]

This is not going to be worked out it seems if statement works but straight line is varies according to the other expressions.

But I am looking for a solution what I have attached Chart Expected.

Thanks,