topic Re: Re-sizing Trellis Charts in QlikView

Re-sizing Trellis Charts

Tue, 09 Aug 2011 22:01:37 GMT

I suspect I know the answer to this, but I thought I'd ask.

I want to make a trellis chart to show values on three countries (from a list). QV clearly calculates the allowable size of the trellis chart from the number of possibly results...

(Has a think - maybe if I set up an inline table with only the three countries in it, with two fields, country & MajorCountry, then use MajorCountry as the Dimension - hmmm, that didn't work :-()

I understand how to use ctrl-shift to adjust the chart area within the box, but is there a way to force the sizing of the trellis chart?

Bob

Re-sizing Trellis Charts

johnw — Tue, 09 Aug 2011 22:29:14 GMT

You can use a fixed number of rows and columns under the trellis settings. Is that what you mean?

Re-sizing Trellis Charts

Wed, 10 Aug 2011 08:49:22 GMT

No, I understand that, but the trellis charts do not scale to fit the size of the area available. I want to make the charts scale to make the most of whatever area I define for the whole group.

Re: Re-sizing Trellis Charts

johnw — Wed, 10 Aug 2011 16:58:52 GMT

Ah! That I don't know, and I'm curious myself. I don't really use trellis charts, but when I've poked at them, I've seen that same problem. I don't know how to fix it.

Re: Re-sizing Trellis Charts

Wed, 10 Aug 2011 17:23:42 GMT

I can achieve the Desired when I force the number of rows to be fixed at 1.

Re: Re-sizing Trellis Charts

Wed, 10 Aug 2011 18:12:36 GMT

Thanks - going to one row gets me much nearer, but not quite near enough.

Never mind, plan B awaits....

Re-sizing Trellis Charts

hdonald — Mon, 15 Aug 2011 15:42:12 GMT

Hi,

Maybe a macro would help with a more dynamic setting of rows and columns in the trellis chart ? e.g.

Set the number of columns to '3' but have a 'vCol' variable that sets a lower value if selections have reduced the number of columns =if(GetPossibleCount(country)<3,GetPossibleCount(country),3).

Set up a similar 'vRow' variable with another expression (depending on range expected).

then set up a macro, triggered OnActivate (for the sheet) and OnAnySelect (for the document) to do the following;

set c=ActiveDocument.GetVariable("vCol")

set r=ActiveDocument.GetVariable("vRow")

set chart = ActiveDocument.GetSheetObject("CH01")

set p = chart.GetProperties

p.ChartProperties.TrellisProperties.EnablePrimaryDimension=true

p.ChartProperties.TrellisProperties.EnableSecondaryDimension=False

p.ChartProperties.TrellisProperties.Columns=c.GetContent.String

p.ChartProperties.TrellisProperties.Rows=r.GetContent.String

chart.SetProperties p

That might give you the layout control you're looking for,

Regards,

Re: Re-sizing Trellis Charts

orital81 — Wed, 24 Jul 2013 10:42:45 GMT

Hi HD

Although this is an old post, I would like to clarify your reply which is relevant to me right now.

I tried to use your Macro suggestion but it didn't work.

Attached my model, Can you please assist?

Re: Re: Re-sizing Trellis Charts

Mon, 07 Oct 2013 15:05:40 GMT

Hi Ori Tal,

I was looking the file you sent and the macro works, only you have to configure the trigger on the document.

You should set the action in the variable in the Document Properties options

Attached the new file

Regards

Thomas M.

Re: Re-sizing Trellis Charts

Thu, 21 Nov 2013 12:10:30 GMT

Hi,

You can simply go to trellis properties and change the number of rows to number of values you want to trellis for (say 2 if you want to trellis for 2 countries) and change number of rows to 1. It worked for me.

Regards,

Abhinav Garg

Re: Re-sizing Trellis Charts

datanibbler — Thu, 21 Nov 2013 12:21:55 GMT

Hi abhinav garg,

I experimented with Trellis_type charts a while ago: You can set the nr. of rows and columns, given you have the screen_space to do it (if you have 3 values on that dimension, you get 3 charts, so it's better to display them in 1 row - so you need a lot of space horizontally - otherwise you'll have one of the four quarters of your charting_area blank...)

You can resize any part of the charts by clicking into the area once, then pressing Ctrl+Shift and dragging or resizing the field you want.

Best regards,

DataNibbler

Re: Re-sizing Trellis Charts

Sun, 23 Nov 2014 00:38:29 GMT

sizing Trellises is witchcraft.