3 Replies Latest reply: Oct 6, 2010 4:57 AM by Gareth Joubert RSS

    First Sold date as Dimension

    Gareth Joubert

      Hi

      Within Qlikview 9 I have set up a table as follows:

       

      PeriodsF2011 P01F2011 P02F2011 P03F2011 P04
      ProductCategoryDescritpion
      1BeefSteak101204307410
      2PoultryChicken thighs202180158136
      3PorkPork Loin50658095


      I need to add, as a dimension, the first sold date (Field name "InvoiceDate") regardlessof the active selections.

      The closest I have got is an expression by using min(invoicedate), however this splits it by the periods.

      Any help/suggestions would be appreciated.

      Thanks, Gareth

      Status: New to Qlikview ;-)