Xav Dou Posted March 13, 2020 Share Posted March 13, 2020 Hi, I would like to use a filter and a property control to apply 2 different filters on the same table in my visualization. It works well if i use one or the other one but together it hides all the data. It alsoworks well if i use a dropdown filter instead of a property control but i don't want the choice of "All" values in my filter (it is not available in a property control) For the filter, i insert it in the text area and i use a List box filter to filercolumnA For the property control, i create a document property with a dropdown list and i usethe "Limit Data using expression" in the table property to filter columnB. Any idea how tol solve that Link to comment Share on other sites More sharing options...
Kirsten Smith (she/her) Posted March 13, 2020 Share Posted March 13, 2020 Shouldn't be any issue using both of these options, please provide a sample DXP file that we can use to investigate further. Link to comment Share on other sites More sharing options...
Tyger Guzman 2 Posted March 13, 2020 Share Posted March 13, 2020 Its definetly possible but from your description I can deduce that your Filter and Limiting Expression are filtering different items and in general if Filtering is applied to a visual with a data limting expression it will do an AND (Filtering = True and Limting=True) , what you want is (Filtering=True or Limiting =True) which is not possible. You'll want to use two document properties and use both in a limiting expression to achieve your goal. But yes please post an example dxp. Link to comment Share on other sites More sharing options...
Xav Dou Posted March 19, 2020 Author Share Posted March 19, 2020 Thank you @Kirstens and Tyger0951 I went for 2 property controls and the one where i wanted to keep the option "All", I got my solution there:https://community.spotfire.com/questions/it-possible-bring-all-option-drop-down-instead-none-option-tibco-spotfire Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now