Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
MarioR
Contributor II
Contributor II

Disable Filter When Clicking on Table Cell

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

MarioR_1-1619544732167.png

 

MarioR_0-1619544685451.png

MarioR_2-1619544761955.png

 

 

1 Solution

Accepted Solutions
joaopaulo_delco
Partner - Creator III
Partner - Creator III

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)
Help users find answers! Don't forget to mark a solution that worked for you!

View solution in original post

4 Replies
JuanGerardo
Partner - Specialist
Partner - Specialist

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

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

JG

joaopaulo_delco
Partner - Creator III
Partner - Creator III

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)
Help users find answers! Don't forget to mark a solution that worked for you!
MarioR
Contributor II
Contributor II
Author

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?

MarioR
Contributor II
Contributor II
Author

I used Pivot Tables and it worked, thanks!