topic Select multiple values in a Straight Table or Search using a >, <, >=, or <= in QlikView

Select multiple values in a Straight Table or Search using a >, <, >=, or <=

Mon, 17 Jan 2011 20:52:30 GMT

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.

Thanks,

Aline

Select multiple values in a Straight Table or Search using a >, <, >=, or <=

Oleg_Troyansky — Mon, 17 Jan 2011 21:44:53 GMT

For Dimensions, you can use Dropdown Select. For Expressions like Revenue, use "Searcheable". Both settings are defined at the "Presentation" tab of the Chart Properties dialog.

Select multiple values in a Straight Table or Search using a >, <, >=, or <=

Mon, 17 Jan 2011 21:50:20 GMT

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?

Select multiple values in a Straight Table or Search using a >, <, >=, or <=

Oleg_Troyansky — Mon, 17 Jan 2011 22:34:06 GMT

Click on the "magnifying glass" icon next to the Expression Heading, and type >350000 as a search string. Press Enter.

Select multiple values in a Straight Table or Search using a >, <, >=, or <=

Mon, 17 Jan 2011 23:00:56 GMT

Hi Oleg,

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?

Sum

({$ <Year={$(=Year(vAnalysisAnchorDate))}, Month={$(=Month(vAnalysisAnchorDate))}>} Revenue)

Any help is appreciated.

Thanks,

Aline