Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using an expression as a filter

Hi Qlik community,


I was wondering if there was any way for me to use an expression (count, sum, avg, etc) as a filter. For instance, I have a thousand individuals (each with a distinct ID) and they have transacted with us several times (transaction ID). Is there a way for me to easily filter for individuals with 3 transactions (count(trans_id) or 5 transactions or 3, 4, or 5 transactions. Or filter for these individuals by total amount they spent with us (sum(price).


To take this one step further, is there a way for me to use the slider tool to say, hey, I only want to see the individuals with 3-5 transactions or 5-10 transactions, while having this criteria apply to the other filters/list boxes that are part of the same state.

Thanks so much!

1 Reply
maxgro
MVP
MVP

you can click in listbox caption and type an expression as in image

1.png

or a slider with expression

=aggr(count({1}TransID),ID)

1.png