topic Ignore filters in table dimension in App Development

Ignore filters in table dimension

dcpadilla — Tue, 02 Oct 2018 16:49:11 GMT

I would like a dimension (not a calculated dimension) to ignore a specific filter. I understand the syntax for ignoring filters in a measure or calculated dimension but this has me stumped.

As an example, I have a Client filter and a Client dimension in a table however I do not want the table to change when a user selects a Client name in the filter.

Any ideas?

Re: Ignore filters in table dimension

linjiao2c — Tue, 30 Oct 2018 03:34:14 GMT

Hi Daniel,

I also encountered the same situation, and find it difficult to do it in expression.

I am planning to load duplicated variables when loading data, and supposed by using the duplicated variables, the dimension in the table will not change when filtering.

You may also have a try.

Re: Ignore filters in table dimension

Lauri — Tue, 30 Oct 2018 19:29:56 GMT

Have you tried using an aggregation function like Concat() with set analysis to ignore the dimension?

Re: Ignore filters in table dimension

vitaliichupryna — Wed, 31 Oct 2018 09:02:56 GMT

Hi Daniel,

I have one idea, you can use Straight table, add necessary dimensions and instead of real expressions add simple expression with set analysis, for instance: sum({<Client=>}1). In my example I use column type

After this you will have table with necessary data and this table will ignore selections in the Client filter.

Also straight table provides possibility to hide columns, so you will hide you measure sum({<Client=>}1)

See screenshots below.

Presentation Tab

Added expression and select 2 in type column - table shows all data that I have

Hide measure column and select 1 and 2 in type column - table still shows all data.

Thanks,

Vitalii