Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
vlad_komarov
Partner
Partner

Reference lines for each section of the trellis chart

Hello,

I have data displayed in bar chart with trellis:

ref_lines0.jpg

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:

ref_lines.jpg 

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

1 Solution

Accepted Solutions
johnw
Champion III
Champion III

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.

View solution in original post

5 Replies
whiteline
Master II
Master II

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.

vlad_komarov
Partner
Partner
Author

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.

ref_lines_expression.jpg

I need something like this:

ref_lines_needed.jpg

johnw
Champion III
Champion III

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.

View solution in original post

vlad_komarov
Partner
Partner
Author

Great idea, John!

This was exactly what I need!

Thank you!

Best regards,

Vladimir

changmy1
Contributor
Contributor

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!