Using an expression as a filter

Wed, 18 Mar 2015 21:49:46 GMT

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!

Re: Using an expression as a filter

maxgro — Wed, 18 Mar 2015 22:16:31 GMT

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

or a slider with expression

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

topic Re: Using an expression as a filter in QlikView

Using an expression as a filter

Re: Using an expression as a filter