Trellis Container not showing data or showing same value for each chart

glebret — Wed, 25 Jun 2025 08:00:46 GMT

Hi,
I've been havving issues with the trellis container since it came out in the vizualisation bundle of Qlik Sense and it is getting very frustrating.

I am using master dimensions and master measures, inner and outter set analysis in my applications, nothing too complicated though.
However, the trellis container never works as expected.

Here is an exemple.
I have a pie chart with:
- 1 master dimension 'Departement' created from the field DEP.DEPARTEMENT.
-the following Master measures:
EPT = sum(real_hours)/sum(contract_hours)
For angle:
Effective_EPT = Sum([EMP_PER.Occupation_pcent])/100/count(distinct [EMP_PER.Salaires_periode])
For Radius:
Wk_EPT = {<$(=vTimeSelection)>} EPT/Count(Distinct EMP_PER.Salary_period))

This pie chart works great on its own and I created a master vizualisation.

Then, I wanted to use the trellis container to get 1 chart per establishment.
Thus, I used the master dimension establishment with my master vizualisation.

I've tried all possible solution, all suggestions from advanced mode...nothing works properly.
On this specific example, I managed to have it work properly by doing so: I unlinked all master items on the source chart, activated the advanced mode and changed my 2 measures to:
- Sum({<[SUB.Etablissement] = {$(vDimValue)}>}[EMP_PER.Occupation_pcent])/100/count(distinct [EMP_PER.Salaires_periode])
- {<$(=vSelectionTemporelle), [SUB.Etablissement]={$(vDimValue)}>}(EPT/count(distinct [EMP_PER.Salaires_periode]))

If I do that, I cannot use the original chart but I need to show the original chart and the trellis.
Moreover, I've tried this workaround with a pivot table but it doesn't work.

On top of that, getting rid of all master items is a real hassle in terms of maintenance.

Can anyone please help out ?

Thanks

Gerald

Re: Trellis Container not showing data or showing same value for each chart

Daniel_Castella — Tue, 07 Oct 2025 13:13:31 GMT

Hi Gerald

Try to use in the master item these other variables available in the advanced mode for trellis container. The measures should be like that:

Sum($(vDimSetFull) [EMP_PER.Occupation_pcent])/100/count(distinct [EMP_PER.Salaires_periode])

{<$(=vSelectionTemporelle) $(vDimSet)>}(EPT/count(distinct [EMP_PER.Salaires_periode]))

Kind Regards

topic Re: Trellis Container not showing data or showing same value for each chart in App Development

Trellis Container not showing data or showing same value for each chart

Re: Trellis Container not showing data or showing same value for each chart