topic Re: Reference lines for each section of the trellis chart in QlikView

Reference lines for each section of the trellis chart

vlad_komarov — Thu, 18 Oct 2012 15:06:53 GMT

Hello,

I have data displayed in bar chart with trellis:

I need to have reference lines displayed for each level (2, 3, 4 in the chart above) separatelly.

I've created several reference lines, but they all displayed together:

Any suggestions how to do that (display reference line for individual section only)?

I have two dimensions in this chart (Level and Term).

Thank you!

Regards,

Vladimir

Re: Reference lines for each section of the trellis chart

whiteline — Thu, 18 Oct 2012 17:03:15 GMT

Hi.

I think you can't use reference lines for that purposes (it seems it's calculated for the entire chart once similar to Max/Min ranges for axises).

Try switch to Combo Chart and add that lines as separate expressions with TOTAL modifier.

Of course the lines will be truncated but it's something to try.

Re: Reference lines for each section of the trellis chart

vlad_komarov — Thu, 18 Oct 2012 19:06:38 GMT

I've tried that before, but this approach does not give me an option to display another expression only at the section I need it at. I can show/hide it, but it appears on all sections of the trellis chart.

I need something like this:

Re: Reference lines for each section of the trellis chart

johnw — Fri, 19 Oct 2012 01:04:08 GMT

You can build reference lines by actually making the lines part of the chart instead of reference lines. See the attached. The horizontal lines are easy. I used a pick(match()) to generate values, but I assume they're calculated in some way in your real application. The vertical lines are kind of insane, but aren't what you need.

Re: Reference lines for each section of the trellis chart

vlad_komarov — Fri, 19 Oct 2012 03:14:05 GMT

Great idea, John!

This was exactly what I need!

Thank you!

Best regards,

Vladimir

Re: Reference lines for each section of the trellis chart

Anonymous — Fri, 18 Jul 2014 03:02:27 GMT

Hi John, I am not able to view the example attached as I have the personal edition. I am trying to set reference lines for different gross margin targets for different segments / business units. How'd I achieve that?

TIA!