Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
adamjwchen
Contributor III
Contributor III

How to filter the result of an expression field

Hi,

I use pivot table to make a table like below, SALES(TAX) is a field calculated from expression.

Is there any way I can have a list box or something else to filter the expression result. For example, SALES(TAX) >= 2500.

1 Reply
marcus_sommer
MVP & Luminary
MVP & Luminary

You could use a search-expression on a listbox for your ID like:

=sum(Sales])>2500

or as an alternatively a listbox with a calculated dimension like:

class(aggr(sum([Sales]), Year, Month, ID), 2500)

- Marcus