Disable Filter in the table

[louise119]

Hi. I want to ask about filter and output result table.
When I select data in the output result table, I want nothing to happen (the filter condition does not change).

I'm trying to narrow down the conditions with a filter and display the selected conditions in a table.
As you select some values in this output table, the filter criteria will change accordingly.
Is it possible to lock or disable the result table so that nothing changes when clicked?

I tried "only" or "{1}",but these didn't work because the data on an axis, not a measure.

Thank you.

[BrunPierre]

Hi, you could also block selections on dimensions within your expression.

In an expression like this Dim1, Dim2 and Dim3 wouldn't affect it.

=Sum({$<Dim1=,Dim2=,Dim3=>} Sales)

[louise119]

thank you,
I think we can't use "Sum" on dimensions.
Can we use "sum" on dimensions?

[BrunPierre]

Perhaps as a calculated dimension.

=Aggr(only({$<Dim1=,Dim2,Dim3=>} UsedDimension), UsedDimension)

[louise119]

thank you,
what is the Dim1 Dim2 Dim3 and UsedDimension??

[BrunPierre]

Maybe you could share sample data and the expected output.

[louise119]

thank you,

I just want to disable the filtering "Name". I want to fix the data.
If the current state, we can filter the data "Office" and "Name".

 

[BrunPierre]

For example, if your expression reads

Only(Name)

By doing this you disregard the selections made in Office and Name fields.

Only({<Office=, Name=>} Name)

[louise119]

thank you,
I tried that, but I can't use "only" on the dimensions....

I also tried that on measures, but only hyphen is shown.

[BrunPierre]

Share your Qlik Document (.qvf) file.