Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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

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


or a slider with expression