Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Trellis in Qlikview

Hello,

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

How trellis are helpful for analysis?

Regards,

Balraj

6 Replies
Colin-Albert
Partner - Champion
Partner - Champion

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.


MK_QSL
MVP
MVP

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.

Anonymous
Not applicable
Author

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

PrashantSangle

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.

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
PrashantSangle

Hi,

I am enclosing that file.

Hope it will help you.

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
MK_QSL
MVP
MVP

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..