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
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
skkrishna
Contributor III
Contributor III

Trellis Container Advance mode issue, Same Pivot Table is repeating for all the dimension

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 

 
we thought of creating One Master  item of that pivot table adding dimension DF 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 the problem here is same charts are repeating for all the charts in trellis, after turning on ADVANCE MODE Option
 

If I turn off Advance mode then '-' values is populating in the pivot table.

 

Please help me on this.

0 Replies