https://community.qlik.com/t5/App-Development/Dimension-exclude-filter/m-p/1533507#M38427 <P>Hello folks, I am trying to figure out the following.</P><P>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.&nbsp;</P><P>For instance, if a user selects "Single Family" from the filter, then the table will show all the other types EXCEPT this one.&nbsp;</P><P>I believe there was a {-1}, but I cant seem to come up with the correct expression</P><P>Is this possible and how, thank you in advance.&nbsp;</P> Tue, 22 Jan 2019 19:30:12 GMT alemberg 2019-01-22T19:30:12Z https://community.qlik.com/t5/App-Development/Dimension-exclude-filter/m-p/1533507#M38427 <P>Hello folks, I am trying to figure out the following.</P><P>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.&nbsp;</P><P>For instance, if a user selects "Single Family" from the filter, then the table will show all the other types EXCEPT this one.&nbsp;</P><P>I believe there was a {-1}, but I cant seem to come up with the correct expression</P><P>Is this possible and how, thank you in advance.&nbsp;</P> Tue, 22 Jan 2019 19:30:12 GMT https://community.qlik.com/t5/App-Development/Dimension-exclude-filter/m-p/1533507#M38427 alemberg 2019-01-22T19:30:12Z https://community.qlik.com/t5/App-Development/Dimension-exclude-filter/m-p/1533707#M38450 <P>Try it with e() like: sum({&lt; "Property Type" = e("Property Type") &gt;} Value)</P><P>- Marcus</P> Wed, 23 Jan 2019 09:43:10 GMT https://community.qlik.com/t5/App-Development/Dimension-exclude-filter/m-p/1533707#M38450 marcus_sommer 2019-01-23T09:43:10Z