Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Can I filter on table column e.g. where greater than a number?

Hi,

I would like to filter my table based on a formula on a column. For example, I have a column which shows how much a person has spent and I want to filter on people who have spent greater than £100 (for example).

Is there a simple way to achieve this?

Thanks
Mark

Tags (3)
3 Replies
MVP & Luminary
MVP & Luminary

Can I filter on table column e.g. where greater than a number?

Mark,

if you need to filter in your load script, you simply reload your table (with no concatenation) with a regular "where" clause.

In the runtime, you can use "Advanced Search" to define the formula. It's usually more than most users would like to do, so you might have to write a small macro to achieve that.

Oleg

MVP & Luminary
MVP & Luminary

Can I filter on table column e.g. where greater than a number?

You can use search with formulas via "Advanced Search" (right click) on listboxes.

There is no search for tableboxes.

Not applicable

Can I filter on table column e.g. where greater than a number?

Thanks gents.

Will look into this and have a play.

Regards
Mark