Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

mazacini
Not applicable

Reference Lines in Guage Chart in Trellis

Hi

I have a Guage Chart with single dimension (3 values) and single expression.

I select Trellis option, and I get 3 Guage Charts showing calculation for each dimension value.

Now I want to introduce a Reference Line, based on a new expression.

The problem is that the expression calculates for the TOTAL dimension. I wanted it to calculate for each of the 3 dimensions.

Attached image show how Reference Line is same for each chart.

I want Reference Line to reflect values as shown in table.

Tks

JoeRefLine Qry.png

Tags (1)
2 Replies
johnw
Not applicable

Re: Reference Lines in Guage Chart in Trellis

It's "impossible" so far as I know.  I believe that reference lines in a trellis chart are always calculated for the whole thing, not each sub chart.  But see the first attached file for a workaround using expressions in a bar chart.  Unfortunately, I can't see how this would work for a linear gauge.  So I'm not thinking of any solution for your specific problem.

Well, unless you want to make a fake trellis chart out of multiple charts, in which case you can use regular old reference lines, but that's a lot of trouble, and I don't guarantee how robust it would be.  See second attached file for that.

mazacini
Not applicable

Reference Lines in Guage Chart in Trellis

Hi John

Apologies for not acknowedging your response earlier.

Problem is, I'm still trying to work out what it is you are doing!

Bear with me.

By way of background, the problem arose from client dissatisfaction with the range of symbols which were available in a Combo Chart - simple line symbols (one horizontal, one vertical) woudl resolve my issue.

(BTW, It is the subject if an Idea - might be worth a vote?)

http://community.qlik.com/ideas/2101