Discussion Board for collaboration related to QlikView App Development.
Hi Qlik experts,
I have a requirement to rank a salesman within a store, the issue I can't handle is due to this store being an expression, because the salesman can be in a different store on each day.
What I need is after select ing a date, I want to see the last store this salesman worked (I got that using firstsortedvalue) and the rank of this salesman in this store. I tried to use rank (aggr(...) but I got "nested aggreagation not allowed".
The app follows attached, the left chart is with the expression commented.
thanks in advance
Rank in the store across all dates or just the selected date? What is the expected output you hope to see here?
May be one of these
2) Aggr(Rank(Sum(SalesValue)), Store, SalesmanName)
thanks again for replying.
I had this solution when the store were fixed, but now with the dynamic store I need rank the salesmen based on the last store where they were allocated, if we got no filters , with this solution, we'll have null. (sorry I didn't specified that on the thread).
Hi Sunny, my expectation is:
selecting all dates
selecting 43101 and 43102: