topic another variable in selection in QlikView

another variable in selection

mv — Fri, 30 Nov 2018 15:27:10 GMT

I have data:

stores: logo, name, limit_from, limit_to

orders: logo, client_id, value, order_id

I need to calculate to each store orders with the value between limit_from and limit_to (different for stores).

I have an expression:

count({<value={">$(limit_from)"},value={"<$(limit_to )"}}distinct order_id)

but it is true for every row, I have the same answer like expression count(distinct order_id)

Thanks for Your help.

agigliotti — Fri, 30 Nov 2018 15:59:41 GMT

maybe this:
count( distinct if( value > limit_from and value < limit_to, order_id ) )

bharatchauhan — Fri, 30 Nov 2018 17:08:27 GMT

Try this expression:

AGGR(COUNT({<value={">$(limit_from) < $(limit_to )"}>}DISTINCT order_id),name)

Hope this might help you!

mv — Sat, 01 Dec 2018 06:18:55 GMT

So simple and it works!

thanks! m.