Stop filter from changing table content

[rish]

Hi,

I am trying to find a formula for stopping a filter from affecting a table. I have a formula that can be used for measures:

count({<field1>}field2) but this only works for measures, and wont work for dimensions or tables.

Thanks,

Rish

[simonaubert]

Hello,

I think you can play with alternate state. 

1/Create an alternate state in your master items

2/drag and drop it on your chart

3/the usual selections don't apply to the chart 🙂

https://community.qlik.com/t5/Qlik-Sense-Advanced-Authoring/NEW-Qlik-Sense-Alternate-States-capabili...

[Vegar · Accepted solution]

Is this what you are looking for?

=aggr(only({<field1=>}field2), field2)

[rish]

thanks a lot!!!