Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

dmac1971
Contributor II

Recommended List Analysis

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 :

Sales
CustomerDateItemDescQty
Mularkies01/02/201410.12.45Flag15
Stevens15/03/201410.12.55Pole30
Road Rash Co02/04/201410.12.632Rope10
Stevens05/05/201410.12.654Grass Seed52
Road Rash Co15/03/201410.12.45Flag5
Mularkies02/04/201410.12.55Pole10
Road Rash Co15/03/201410.12.200Deck Chair25
Jones Co01/02/201410.12.45Flag14

Recommended List :

Recommended
  Parts
ItemDescRec Qty
10.12.45Flag5
10.12.55Pole15
10.12.632Rope15
10.12.654Grass Seed30
10.12.200Deck Chair5
10.12.5555Parasol20
10.12.1234Table2

What I'm seeing now :

Recommended
  Parts Results
ItemDescRec QtyPurchasedPassed?
10.12.45Flag534Y
10.12.55Pole1540Y
10.12.654Grass Seed3052Y
10.12.200Deck Chair525Y

ie I'm missing the items what the customer hasn't purchased!

What I'd Like to see :

Recommended
  Parts Results
ItemDescRec QtyPurchasedPassed?
10.12.45Flag534Y
10.12.55Pole1540Y
10.12.632Rope1510N
10.12.654Grass Seed3052Y
10.12.200Deck Chair525Y
10.12.5555Parasol200N
10.12.1234Table20N
1 Reply
MVP
MVP

Re: Recommended List Analysis

PFA

Community Browser