Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
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

3 Replies
Oleg_Troyansky
MVP & Luminary
MVP & Luminary

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

rbecher
MVP & Luminary
MVP & Luminary

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

There is no search for tableboxes.

Vizlib Head of R&D
Not applicable

Thanks gents.

Will look into this and have a play.

Regards
Mark