topic Disable Filter in the table in App Development

Disable Filter in the table

louise119 — Fri, 15 Nov 2024 21:56:32 GMT

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.

Re: Disable Filter in the table

BrunPierre — Mon, 03 Apr 2023 10:29:11 GMT

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)

Re: Disable Filter in the table

louise119 — Mon, 03 Apr 2023 10:39:38 GMT

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

Re: Disable Filter in the table

BrunPierre — Mon, 03 Apr 2023 15:15:44 GMT

Perhaps as a calculated dimension.

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

Re: Disable Filter in the table

louise119 — Mon, 03 Apr 2023 12:47:57 GMT

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

Re: Disable Filter in the table

BrunPierre — Mon, 03 Apr 2023 13:37:37 GMT

Maybe you could share sample data and the expected output.

Re: Disable Filter in the table

louise119 — Mon, 03 Apr 2023 14:01:28 GMT

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".

Re: Disable Filter in the table

BrunPierre — Mon, 03 Apr 2023 15:38:08 GMT

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)

Re: Disable Filter in the table

louise119 — Mon, 03 Apr 2023 23:51:46 GMT

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.

Re: Disable Filter in the table

BrunPierre — Tue, 04 Apr 2023 07:34:14 GMT

Share your Qlik Document (.qvf) file.