Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
thank you,
I think we can't use "Sum" on dimensions.
Can we use "sum" on dimensions?
Perhaps as a calculated dimension.
=Aggr(only({$<Dim1=,Dim2,Dim3=>} UsedDimension), UsedDimension)
thank you,
what is the Dim1 Dim2 Dim3 and UsedDimension??
Maybe you could share sample data and the expected output.
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".
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)
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.
Share your Qlik Document (.qvf) file.