8 Replies Latest reply: Jun 29, 2012 2:07 AM by Yogananthan Arjunan RSS

    Need help to resolve this problem

      SHOPIDCheckOutEventTimeCHECKOUT with Max_EventTimeCount_CHK1Count_CHK2
      1CHK15


      1CHK210CHK2
      1
      2CHK130CHK11
      2CHK25


      2CHK210


      3CHK17


      3CHK29CHK2
      1




      12




      CHK1CHK2

       

      I came across a scenario as below and need your kind help to solve it in QlikView.

       

      Scenario:

      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).

       

      Calculation:

      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.