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

[SK28]

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? 

[MEDHA07]

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.

[SK28]

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.

[SK28]

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]

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)