Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
What are trellis in qlikview? In which scenario we can use trellis?
How trellis are helpful for analysis?
Regards,
Balraj
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.
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.
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
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.
Hi,
I am enclosing that file.
Hope it will help you.
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..