Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

keep all filters when selecting cells in a pivot

Hello

I have a pivot table.

When I select a cell, say intersection: value1 || A, everything works fine. However if I then select value3 || A, the A filter disappears.

Every cell the user selects should pass both filters, not remove one if it happens to be from the row.

How to do I achieve this behaviour?

Thank you,

Andy.

col1headergroup1valueheadergroup2value

A

value1value3
Bvalue2value4
6 Replies

Re: keep all filters when selecting cells in a pivot

You shouldn't 'select' values in expression cells. Expression values cannot be selected. Clicking on such a value will select all the dimension values used in calculating the value in that cell.


talk is cheap, supply exceeds demand
Not applicable

Re: keep all filters when selecting cells in a pivot

my customers don't agree.

we want the ability to select a cell and display details in another table.

any other suggestions how I can make this happen?

Re: keep all filters when selecting cells in a pivot

Yes, well. You're customers may not agree that the earth is not flat. You try to make the earth flat. I'm not going to waste time trying, ok.


talk is cheap, supply exceeds demand
elizafilip_2014
Contributor II

Re: keep all filters when selecting cells in a pivot

Try to use for the request: "the ability to select a cell and display details in another table." the Container Object with two table (summary and details). In Presentation - Container Type chose Grid  with  1 Column and 2 Rows.

Not applicable

Re: keep all filters when selecting cells in a pivot

Please, are there any other experts willing to help?

All is working except when I select another cell. is there a second approach I could take?

I notice that all dimensions are being selected when I click the expression, however when I click an adjacent cell and that cell shares the same value in one or more dimensions, it removes the filter. I need a way of applying every dimension value, every time a cell click event occurs.

I should add that my pivot table is using set analysis expressions so the table doesn't collapse when a cell is selected.

Thank you.

Not applicable

Re: keep all filters when selecting cells in a pivot

Hi Eliza

Thank you for your response.

The details functionality is working fine, its when I select another cell where the issues arise.

Andy.

Community Browser