topic Re: Disable Filter When Clicking on Table Cell in App Development

Disable Filter When Clicking on Table Cell

MarioR — Tue, 27 Apr 2021 17:35:23 GMT

Hi!

I'm developing an App in Qlik Sense Enterprise. The reason I'm making this question is because I want to disable a filter.

Right now, I have a table that whenever you click in a cell, Qlik automatically sets a filter on the entire dashboard. So, is there a way to disable that and to make the table remain static (see screenshots)?

Thanks,

Mario

Re: Disable Filter When Clicking on Table Cell

JuanGerardo — Tue, 27 Apr 2021 17:52:01 GMT

Hola @MarioR, You can try to add to the table an expression that calculates for all elements, for example:

Max({1} [Última Modificación])

Re: Disable Filter When Clicking on Table Cell

joaopaulo_delco — Tue, 27 Apr 2021 17:57:02 GMT

Hi @MarioR !

You can try add this dimension as a measure instead a dimension.

In the table properties, instead you choose a dimension, choose measure and put the follow formula:

Only(Name_of_your_Dimension)

Re: Disable Filter When Clicking on Table Cell

MarioR — Tue, 27 Apr 2021 21:35:04 GMT

Thanks @joaopaulo_delco ,

That seems to be valid, the problem is that the table only accepts "Columns", equivalent to dimensions.

Do you know any chart I can use that is similar to tables but accepts Measures?

Re: Disable Filter When Clicking on Table Cell

MarioR — Tue, 27 Apr 2021 21:46:17 GMT

I used Pivot Tables and it worked, thanks!