Ignore Selected Filters

[MH376]

I do have a table with Dimensions and Measure. I do have a filter which is a dimension available in the table. Is there a way for a table dimension to ignore the selected values? For eg: 

In first screenshot it has Filter and a table. In second screenshot a filter is selected but is there a way to ignore the selected the criteria?

[MatheusC]

Hi, @MH376 

Use the = sign next to the dimension to be ignored, such as Field= in your expression ex:

sum({<Year=$(=max(Year)),Field=>}sales)

Regarts, Matheus

[MH376]

The field is just a dimensional field. So there is no aggregations. Can this be achieved? In above screeenshot even if the Fieldname "Item" is selected the visual table should display all the items irrespective of the selection made. Although "Alice Mutton" is selected, the table should still display all the items along with its Quarter and Sales.

[MatheusC · Accepted solution]

Use {1} to ignore selections

sum({1} sales)

Regats,
Matheus

[themanwithnoname]

To add to Matheus, here is the reference for what's suggested: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalys...