Pivot table expanding all cells of same text

[georgelai]

Hi,

Noticed the pivot table is expanding all cells with the same text.

Is there a way to only expand the one cell the user clicks on?

In the attached screens, when one "Port" cell is expanded. The pivot table expands all "Port" cells.

We only want to expand one cell, not all cells with the same text.

Thanks,

[#2 · Accepted solution]

May be this is the expected behavior on the pivot table. You can contact QlikTech or add the idea to community to gee the votes.

[PradeepReddy]

this is the default behavior... as pointed by Dathu, check with QlikTech

[HirisH_V7]

Hi,

I think its not possible .you can use this for custom layout of the table.  -> Layout -> Options -> untick Size to data.

HTH,

Hirish

[marcus_sommer]

If it's only nice to have then let is like it is. Otherwise and if you are willing to accept additional user-actions by selecting further "control" fields you might get nearer to your wanted views.

This meant if the user selects their special treated fields and within them which dimension-values (probably additionally fields within a data-island) should be shown respectively hidden you could react of them by querying those selections within the expression and if those condition is true return NULL which could be hidden per option. The same approach could be applied by the dimensions and maybe you need to combine both methods to get your goal.

If you decide to try it it meant you will quite a lot of efforts to gain it - it's quite a dirty solution but no quick one. Also if your object already rather slow it will slow down the performance further then you will create a lot of extra calculations.

- Marcus

[jagan]

Hi,

How are you expanding?  When you click on + symbol it is not expanding all the values in that column.  It just expand the + which we click.  Not sure which version are you using?  It is working as expected for me please find attached file.

Regards,

Jagan.

[georgelai]

Thanks for the help.

If Nokia also has 100 sales, it will expand it when you click on the 100+ sign in Apple.

Looks like it's default behaviour.

[marcus_sommer]

I know these behaviour and it happens not always and I haven't yet searched for a reason - there are some undocumented dependencies which options and features are used - hiding NULL or show everything by dimensions, surpress NULL in expressions, using from dimension/expression-groups, set analysis and probably many more.

Maybe you could get rid of them if starts with a complete new pivot and add step by step a dimension/expression and checked the behaviour.

- Marcus