Spotfire filter out data

[Sébastien Medhat 2]

Hello,

I just started using Spotfire and I am having a bit of a tough time figuring out how to filter out data in my table, I need your help.

I have one tab where I want to addtwo different visualizations with the same table :

 

first visualization -> my table with all the rows that match my selected filters

second visualization -> my same table with all the rows that don't match my selected filters

 

Thank you in advanced for your help.

[Kirsten Smith (she/her)]

Click on Properties/Subsets and you can select whether to have filtering settings applies, or show all data.

[Fabian Duerr]

You could work with two different filtering schemes in your visualization or use the option to limit data by expression. Check out the Spotfire help if you are not familiar with that. In both cases you'll be limited in terms of flexibilty. How much flexibility do you need How many filters do you want change

 

I don't know any option to show the inverse of the filtering right away...

 

Things get easier if you could just subset your data for example to group a and group b with any kind of expression (calculated column)

[Fabian Duerr]

Ha, that's so simple. Thank you :)