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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
glebret
Partner - Contributor III
Partner - Contributor III

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

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

Labels (1)
0 Replies