topic Re: Trellis in Qlikview in QlikView

Trellis in Qlikview

Anonymous — Wed, 05 Mar 2014 16:15:38 GMT

Hello,

What are trellis in qlikview? In which scenario we can use trellis?

How trellis are helpful for analysis?

Regards,

Balraj

Re: Trellis in Qlikview

Colin-Albert — Wed, 05 Mar 2014 16:19:44 GMT

Trellis will create a separate chart for each value is the first dimension, so you will need to add an extra dimension to trellis a chart. All charts will share common axis values so they can be compared.

You can only Trellis bit mapped charts, so you cannot trellis straight table or pivot table charts.

Re: Trellis in Qlikview

MK_QSL — Wed, 05 Mar 2014 16:24:46 GMT

Consider that you want to show Sales for 4 different customers for each month i.e. Jan to Dec

You can use Trellis Chart

Please check enclosed file showing two bar charts.

One is normal one and 2nd is trellis.

You will realize when we should use Trellis Chart.

Re: Trellis in Qlikview

Anonymous — Fri, 07 Mar 2014 16:06:36 GMT

Manish,

no enclosure?

Could you tell me steps to create trellis?

I would like to do for same scenario which you have explained.

Thanks for anticipating.

Regards,

Balraj

Re: Trellis in Qlikview

PrashantSangle — Fri, 07 Mar 2014 16:19:53 GMT

Hi,

A trellis chart is a grid of small charts. It is basically a repetition of a chart across a grid. Usually, at least two dimensions are used, one for the grid variable and another for the x-axis within each small chart.

With a trellis chart, you can, not only analyze the metrics within each chart without a query (a selection), but also look at the bigger picture and compare with the rest of the group at the same time. This way, you can easily identify the irregular behaviors among the variables.

This is because individual chart is sharing the same y-axis; therefore, you can accurately compare the metrics across the grid.

for example you can view Data Visualization demo from qlikview.

Re: Re: Trellis in Qlikview

PrashantSangle — Fri, 07 Mar 2014 16:23:58 GMT

Hi,

I am enclosing that file.

Hope it will help you.

Re: Trellis in Qlikview

MK_QSL — Fri, 07 Mar 2014 16:38:36 GMT

The attachment is there...

Create a Bar Chart

Dimension

1) Customer

2) Name

Expression = SUM(Sales)

Under Dimension Tab

Click on Trellis

Enable Trellis Chart

Set Number of Columns and Number of Rows as per your requirements.

Hope this helps..