Discussion Board for collaboration on QlikView Scripting.
I am a novice with Qlikview - have released a couple of QVD generator apps and design apps so bear with me here...
On a SalesPerson level I am trying to work out the monthly revenue drop.
I have no issues working this out on a Customer Level - the the complexity is that the Customer can move from 1 SalesPerson to another each Month.
Please see attached sample data and same output example =- if i can provide nmore info lpease let me know
Solved! Go to Solution.
Actually no that doesnt work
if you look at the month of Feb 2014 you can see the customer moved from Sally to Dave. For Feb the movement should be 0.6 against Dave only. But we are seeing +5.87 on Dave and -5.29 on Sally.
So its just the net 0.6 that should show against Dave.
its the complexity of showing the net Customer movement against the Owning Salesperson at the time.
There are different solutions here, and most of them use Set Analysis. See for instance
Or search for ytd and yoy on the forum.