Show all Value from a Pivot Table even if a cell is selected

[Frédéricdh]

Hello,

i have a pivot table and when I select a cell, Qlik only show the value of the two dimensions who are impacted by the cell.

What must I do to be able to select a cell and in the same time show all the pivot table and the value.

thanks for helping

[edwin]

if the user filters for a field shouldnt the table show only the results for that field?  if you want the field selection ignored (for some user experience not articulated), add set analysis ignoring the selection in all the measures of your pivot table.  your test case is very similar to this thread which ignores the selection in specific measures but your requirement is for all measures - the idea is the same

Expression (Average) that calculates based on sele... - Qlik Community - 2450300

[Frédéricdh]

No I want to speak about a selection in the pivot table.

When you select a value in the pivottable, I want to show all the pivottable and not only the value selected.

[Frédéricdh · Accepted solution]

I found this.

The Pivottable has 2 dimensions PLACE and WEEK and the function is like this Sum (Weight) and the prblem was when I select a cll in the pivottable than QLIk only show the line and column from the selected cell,

But With this Function: Sum({<PLACE, WEEK>} Weight), when I select a cell in the Pivottable, QLik show all the pivottable without reduce the table. I don't understand why but It works.