I came across a scenario as below and need your kind help to solve it in QlikView.
SHOPID is the number given to a 'Shopper' and the Checkout is the checkout number. EventTime is the time spent in each Checkout. Due to an error in location system, a shopper is seen in more than one checkout (i.e Shopper 1 in checkout 1&2 and shopper 2 in checkout 1 and twice in 2 etc.). The correct register is the one that shopper spent most of the time (i.e max EventTime per SHOPID).
Need to count the distinct SHOPID s per CheckOut and display it in a Bar Garph.
A spreadsheet is attached to make it easy to understand.