Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
New navigation header in progress. Thank you for your patience: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
skkrishna
Contributor III
Contributor III

Trellis Container issue, it's showing '-' values for all the dimension when added pivot table to the trellis container

Hi 
 
I have a pivot table, with two dimensions and multiple measures with Indent rows.
The requirement here is to Show that based on the Other dimension (Name DF) which has 5 Distinct data points in that column 
 
Rather than creating 5 different pivot table and then with 1 with total rows.
 
we thought of creating One Master  item of that pivot table adding dimension DF in trellis Container.
 
But the problem here is The pivot table show the values when it is not in trellis Container 

Dimensions                        
Values                    
                   
Month Name                    
Jan Feb  Mar Apr May  Jun Jul Aug Sep Oct Nov Dec
Opt                          
  abc 1.01 1.0302 1.050804 1.07182 1.093256 1.115122 1.137424 1.160173 1.183376 1.207043 1.231184 1.255808
  cdf 1.23 1.2546 1.279692 1.305286 1.331392 1.358019 1.38518 1.412883 1.441141 1.469964 1.499363 1.52935
  xys 0.23 0.2346 0.239292 0.244078 0.248959 0.253939 0.259017 0.264198 0.269482 0.274871 0.280369 0.285976
  efc 0.45 0.459 0.46818 0.477544 0.487094 0.496836 0.506773 0.516909 0.527247 0.537792 0.548547 0.559518
tpo                          
  poi 3.2 3.264 3.32928 3.395866 3.463783 3.533059 3.60372 3.675794 3.74931 3.824296 3.900782 3.978798
  uyt 1.2 1.224 1.24848 1.27345 1.298919 1.324897 1.351395 1.378423 1.405991 1.434111 1.462793 1.492049

 
 
 
 
 
but when i added the pivot table to the Container.
 
Its showing only '-' for all 5 DF's

Dimensions                        
Values                    
                   
Month Name                    
Jan Feb  Mar Apr May  Jun Jul Aug Sep Oct Nov Dec
Opt                          
  abc - - - - - - - - - - - -
  cdf - - - - - - - - - - - -
  xys - - - - - - - - - - - -
  efc - - - - - - - - - - - -
tpo   - - - - - - - - - - - -
  poi - - - - - - - - - - - -
  uyt - - - - - - - - - - - -
  uyt - - - - - - - - - - - -


 
Can anyone please help me on this? 

Labels (2)
4 Replies
HarishM07
Contributor III
Contributor III

Hi,

Are you talking about general container where we can add individual tables and charts? or else

Trellis chart or container which will work based on dimension values?

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

if trellis chart means refer the above link.You can use advanced mode to specify where to insert set analysis and dimension values in the master visualization. Activate it by setting Appearance > Trellis options > Advanced mode to On.

if it is only container means create the individual tables and drag and drop to the container.it will display same.

if you are using any aggr conditions check the granularity which are dimension using in a table and in expression.

skkrishna
Contributor III
Contributor III
Author

Hi,

 

Single Pivot Table should using trellis container and the values must change based on the DF column

After adding the pivot table to the trellis container, I can see the values.

all are showing as '-'

if I copy and paste it in the sheet, the pivot table has values.

 

skkrishna
Contributor III
Contributor III
Author

Please help on this.

 

I have Turned On advance Mode now '-' are replaced by the values.

 

But the problem is the data is not filtering based on DF column, it's showing the default values, wi...

Dimensions                        
Values                    
                   
Month Name                    
Jan Feb  Mar Apr May  Jun Jul Aug Sep Oct Nov Dec
Opt                          
  abc 1.01 1.0302 1.050804 1.07182 1.093256 1.115122 1.137424 1.160173 1.183376 1.207043 1.231184 1.255808
  cdf 1.23 1.2546 1.279692 1.305286 1.331392 1.358019 1.38518 1.412883 1.441141 1.469964 1.499363 1.52935
  xys 0.23 0.2346 0.239292 0.244078 0.248959 0.253939 0.259017 0.264198 0.269482 0.274871 0.280369 0.285976
  efc 0.45 0.459 0.46818 0.477544 0.487094 0.496836 0.506773 0.516909 0.527247 0.537792 0.548547 0.559518
tpo                          
  poi 3.2 3.264 3.32928 3.395866 3.463783 3.533059 3.60372 3.675794 3.74931 3.824296 3.900782 3.978798
  uyt 1.2 1.224 1.24848 1.27345 1.298919 1.324897 1.351395 1.378423 1.405991 1.434111 1.462793 1.492049

 
 same Pivot table is repeating

jfoley808
Contributor II
Contributor II

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)