Discussion Board for collaboration related to Creating Analytics for QlikView.
Lets say I have a list of recommended items we want a customer to buy, ie the ideal stock holding. Then I have a list of what has been sold. I want to map one against the other.
I can easily show a straight table with the list of parts that have been purchased, but it wont show those that are not, I think I need to join the tables?
Sample sales data :
Recommended List :
What I'm seeing now :
ie I'm missing the items what the customer hasn't purchased!
What I'd Like to see :