Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
you can click in listbox caption and type an expression as in image
or a slider with expression
=aggr(count({1}TransID),ID)