Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

2 questions on Trellis Charts

Hi all!

I just started playing with trellis charts a few days ago and have a couple of questions I couldn't find the answers to in the community:

1) Can I add a chart that shows the totals for the dimension I'm breaking into separate charts with the Trellis??

For example, see this (dummy data, 'hand drawn') chart with # of newsletter subscribers by territory.

I'd like to have the 4 quadrant show the total subscribers of all territories put together. Can that be done?

qv_question.png

2) Can I have different axes scales for the different charts? As you can see, Rest of World could safely have vertical axis that max at 1000.

Thanks in advance!

7 Replies
khadeer_sparks
Valued Contributor

Re: 2 questions on Trellis Charts

Hi,

As per my knowledge, Trellis chart, Making the itteration of charts by using the dimension. Here  you are splitting them based on dimension values. Again you are showing total, that not other than normal view.

The scale may be depend on your values. I am not clear you got correct answer from my side. I shared what i know.

Regards,

Khadeer

Employee
Employee

Re: 2 questions on Trellis Charts

1) For your territories dimension enable show total on the Dimension Limits tab of properties.

2) The point of the trellis chart is to compare, thus the option for individual scales have not been implemented.

Not applicable

Re: 2 questions on Trellis Charts

Hi Johan,

Thanks for answering!

1. It doesn't work. What it does is indeed add a 4th quadrant but all it does is show one tall bar at the rightmost of the horizontal axis and no values at all for months.

qv2.PNG.png

2. Makes (some) sense

Thanks again!

Not applicable

Re: 2 questions on Trellis Charts

anyone ?

MVP & Luminary
MVP & Luminary

Re: 2 questions on Trellis Charts

1. Yes, create a new dimension in the script:

Load * inline [

TrellisRegion, Region

US & Canada, US & Canada

S. America, S. America

Rest of World, Rest of World,

Total, US & Canada

Total, S. America

Total, Rest of World

];

Now use the field TrellisRegion as dimension instead of Region in your chart as first dimension.

2. No, all subcharts in the trellis will get the same axis scale. The alternative is to create separate charts that each can have their own scale.


talk is cheap, supply exceeds demand
Not applicable

Re: 2 questions on Trellis Charts

Hi,

Thanks a lot!

I tried it but got a garbage after statement error

(the names of the field and the values are a bit different in this model)

Garbage.PNG.png

any ideas what i'm doing wrong?

Thanks!

Re: 2 questions on Trellis Charts

Hi

Try like this

Load * inline

[

TrellisRegion, "Team Formula"

US, US

..

];