Select multiple values in a Straight Table or Search using a >, <, >=, or <=
Is there a way in QV 9.0 to choose multiple values in a Straight Table? If not, is there a way to do a search that would include a >, <,<>, >=, or <=?
I was going to load an inline table, but the problem is that this is for the Sum(Revenue). Based on the selections, this changes drastically. The values could range from 0 - 40,000,000 with no selections and 0-500 with certain selections. I would need the grouping to be as dynamic as the selections.
This table does not have any visible dimensions since the user requirements wants to be able to sort every column. I have the Searchable option chosen for any relevant columns, but how can I return all values > 350,000 as an example?
I've tried that several times in different ways: ">350000", >350000, >$350,000. Nothing is filtered. I have removed all other searchable fields on the table thinking that it was getting confused about what to filter. Nothing is filtered.
If I use a simple number like 10, it will filter to any values that have a 10 somewhere in the number, but if I choose a larger number like 31229 (1 of the values is 312,292), nothing is filtered. I purposely exclude the last number in case it is rounding.
This is a calculated field with Set Analysis inside. I assumed this messed up the search, but then why would it return if I choose a small value?