2 Replies Latest reply: Feb 4, 2013 9:57 AM by fatih.yaran RSS

    Create  autonumber column ordered by sales date grouped by username


      Hello,
      I have sales table that have usernames and sales_dates. I want to give sales number
      for every sales ordered by date for every user. Then I would like to create a column
      that shows the days between sales.
      Black columns are original data. I would like to produce red data. How can I do that in qlikview?
      UsernameSales_dateSales_noDate_difference
      john14.01.20131
      john17.01.201223
      john25.01.201338
      Wade10.01.20131
      Wade18.01.201328
      Wade31.01.2013313

























































      FUIDSales_dateSales_noDate_diffreence
      John15.01.20121
      John17.01.201222
      John23.01.201236
      Wade16.01.20121
      Wade25.02.2012240
      Wade03.03.201237
      Fred04.04.20121
      Fred09.04.201225
      Fred24.04.2012315
























































      FUIDSales_dateSales_noDate_diffreence
      John15.01.20121
      John17.01.201222
      John23.01.201236
      Wade16.01.20121
      Wade25.02.2012240
      Wade03.03.201237
      Fred04.04.20121
      Fred09.04.201225
      Fred24.04.2012315
























































      FUIDSales_dateSales_noDate_diffreence
      John15.01.20121
      John17.01.201222
      John23.01.201236
      Wade16.01.20121
      Wade25.02.2012240
      Wade03.03.201237
      Fred04.04.20121
      Fred09.04.201225
      Fred24.04.2012315
      FUID
      Sales_date
      Sales_no
      Date_diffreence


      John
      15.01.2012
      1



      John
      17.01.2012
      2
      2


      John
      23.01.2012
      3
      6


      Wade
      16.01.2012
      1



      Wade
      25.02.2012
      2
      40


      Wade
      03.03.2012
      3
      7


      Fred
      04.04.2012
      1



      Fred
      09.04.2012
      2
      5


      Fred
      24.04.2012
      3
      15