Pivot table - Column auto collapse when changing cylic dimension

[fatinfazrizanor]

Hi Support,

I have issue with cyclic dimension in pivot table, when changing the cyclic dimension, the column is auto collapse. Is there any alternative of this so the column does not collapse? Please help me thanks!

Regards,

FT

[BPiotrowski]

Hi, @fatinfazrizanor 

Have you tried expanding table, then going back to edit mode and saving changes for this table? What I know Qlik is saving this state of expansion, that might be it.

[fatinfazrizanor]

Hi @BPiotrowski,

I have done this way but the problem is i have my fields inside my cyclic dimension. It can works in certain dimension, but some are not. And it is not consistent even i applied the save to all the fields. It could be great if there is way to maintain the first column remain expand. 

Regards,

FT

[BPiotrowski]

I have made pivot table with 4 cyclic dimensions, all of them had width set by hand and changing to any dimension did not isued any way. I would suggest checking your app on new version of Qlik and checking the data on straight table if it shows correct data, maybe all is synthetic dimension and has no connection to the tree under it or so, i can only guess by now.