Ignoring Filters without using Set Analysis

[natalia_rodrigues]

Hi guys,

Is that possible in Qlik Sense to ignore filters in dimensions in a table without using Set Analysis? 

I cant use Set Analysis, since I am not using agg functions. I have a simple table with some pure dimensions (I dont use any formula on them) as columns (Ex: Name, Reagion, Projekt Name....).

The reason for that, is that the user may need to export this data in excel format for own analysis. When he exports this table, it should ignore all filters. 

[dplr-rn · Accepted solution]

Use an expression with only function instead of just dimensions. You can use set analysis then.

Other option is alternate states

[natalia_rodrigues]

The problem is that I dont want to aggregate anything, what kind of formula would you use?

[dplr-rn · Accepted solution]

Only function doesn't aggregate. It's results is same as giving a dimension.
E.g.
Only(customer) is same as =customer

https://community.qlik.com/t5/QlikView-Documents/How-to-use-Only/ta-p/1494475

[natalia_rodrigues]

Hi dilipranjith,

It worked using Alternate State.
Thanks!:)