Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dcpadilla
Contributor
Contributor

Ignore filters in table dimension

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?

3 Replies
linjiao2c
Partner - Contributor II
Partner - Contributor II

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.

Lauri
Specialist
Specialist

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

vitaliichupryna
Creator III
Creator III

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

Hide1.png

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

Hide2.png

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

Hide3.png

Thanks,

Vitalii