Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
alemberg
Contributor III
Contributor III

Dimension exclude filter

Hello folks, I am trying to figure out the following.

I have a straight table with about 10 columns. One of those is "Property Type", and lists out types of properties we have in our data set. I would like to create an instance of this straight table for comparison purposes, where the column removes whichever "Property Type" is selected from the Drop Down filter. 

For instance, if a user selects "Single Family" from the filter, then the table will show all the other types EXCEPT this one. 

I believe there was a {-1}, but I cant seem to come up with the correct expression

Is this possible and how, thank you in advance. 

1 Solution

Accepted Solutions
marcus_sommer

Try it with e() like: sum({< "Property Type" = e("Property Type") >} Value)

- Marcus

View solution in original post

1 Reply
marcus_sommer

Try it with e() like: sum({< "Property Type" = e("Property Type") >} Value)

- Marcus