topic Trellis Chart Question in QlikView

Trellis Chart Question

Sat, 14 Nov 2009 23:20:03 GMT

I am trying to create a line trellis chart where the X axis is the Week # and the Y axis is the Sales each line represents a Fiscal Quarter.

Each trellis will represent a product

How do I set up the dimensions to get this to work? I set up the chart without a trellis with the dimensions in this order on the Dimensions tab

Fiscal Quarter

Week #

Product Class

But when I check the trellis button, i get a separate chart for each quarter, not for each product which defeats the purpose of my chart to show Full Accumulation on a weekly basis quarter over quarter. I would attach an image of the chart but do not see an option to do so.

Trellis Chart Question

Oleg_Troyansky — Sun, 15 Nov 2009 02:11:06 GMT

Trellis chart is using the first dimension for the "trellis" effect. In your case, the "Product Class" should be the first dimension, and then each mini-chart will represent an individual Product Class.

Trellis Chart Question

Tue, 17 Nov 2009 01:52:45 GMT

I set it up that way but I cannot get the X axis for my line chart use the WorkDay#. It keeps putting my expression as the X axis. Not sure what I am doing wrong.

Trellis Chart Question

Sat, 21 Nov 2009 23:56:42 GMT

I noticed the issue I am having is when I use Full Accumulation for my charts. I want to see one trellis shart for each quarter showing daily accumulated bookings but it will not allow it for some reason.