Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
maksik
Partner - Contributor II
Partner - Contributor II

Trellis Container Shows The Same Values for the Different Dimensions

Friends,

I have created a trellis.  Assigned different dimensions for the same master bar chart.  And the charts show all different dimensions, but the same values from the master chart. I expect different values based on my dimension.  Can you help me resolve it? Please see the picture. Thank you.

maksik_0-1595535190643.png

 

 

Labels (5)
8 Replies
gsan
Contributor II
Contributor II

Hi Maksik,

Were you able to fix the issue? I am having a similar issue.

Thanks

San

Albert3
Contributor
Contributor

Hi,

I have the same proboblem 😞

 

Albert3_0-1647597881739.png

 

patricesalem
Creator II
Creator II

hi 

 

same issue - have you found a solution ?

IuliaM
Contributor III
Contributor III

Hello Everyone,

I have this issue as well, I must say I was not able to build this object at all, it just shows totals for all the dimension values. and the dimension is not hiding the null ones.

thanks for your help!

IuliaM
Contributor III
Contributor III

Hello Everyone,

 

I might have actually found the issue. this type of chart does not work with calculated dimensions. so as soon as any calculation is make, even a formating this will not work. try to make formating or calculation in the script and once you add the trellis container choose the field directly as a dimension. 

hope this helps,

cheers

Iulia

annapochyla
Partner - Contributor III
Partner - Contributor III

HI Maksik,

have you tried using Advanced mode and set analysis  in chart measures?

In set analysis use placeholders like $(vDimSet) from Trellis chart documentation.

It should help.

https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Visualizations/Visualizat...

patricesalem
Creator II
Creator II

hi

yes - I did and it works !

 

thanks

jfoley808
Contributor II
Contributor II

I finally found the issue.

Make sure there is not an equals sign before your trellis container dimension.

 

If there is, Qlik will write your measure set analysis as:

Sum({< =[Dimension Name]={'Dimension Value'}>}Sales)

 

Instead of

Sum({< [Dimension Name]={'Dimension Value'}>}Sales)