Need to instigate marking from a dropdown Spotfire control?
Usually, there’s some logic around building a custom expression for the data limiting expression field in Spotfire. When you simply need to exclude certain values you may not want to type out the formula in the custom expression window. This is where Excel tricks come in handy!
- Have you wanted to to limit calculated columns to a smaller data set but been unable to because calculated columns always take into account the entire data set?
- Have you ever wanted IF statements to be more dynamic?
- Would you like to build filtering or data reduction into a workflow but still maintain the original data connections?
Sometimes you’ll get data back that has been tagged. This can be frustrating in Spotfire because at present there is no method for either splitting these apart or delimiting them into a single category.