topic Re: Show all Value from a Pivot Table even if a cell is selected in App Development

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

Frédéricdh — Wed, 08 May 2024 13:29:48 GMT

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

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

edwin — Wed, 08 May 2024 14:41:07 GMT

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

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

Frédéricdh — Fri, 10 May 2024 07:44:45 GMT

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.

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

Frédéricdh — Mon, 13 May 2024 12:28:09 GMT

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.