4 Replies Latest reply: Jan 24, 2013 4:25 AM by Mathias Mühlfelder RSS

    Transforming CSV / QVD import

    Mathias Mühlfelder

      Hi Qlikview Community,

       

      I am strugling with the following challenge and don't get it solved.

      I have a CSV / QVD file in the following format:

       

       

      Date
      PartnerItems_Total
      Items_Successfull
      01.01.2013DEMO108
      01.01.2013DEMO210070
      02.01.2013DEMO2015

       

      Now I would like to have the data in Qlikview in the following way:

      DatePartnerItemsStatus
      01.01.2013DEMO8successfull
      01.01.2013DEMO2unsuccessfull
      01.01.2013DEMO270successfull
      01.01.2013DEMO230unsuccessfull
      02.01.2013DEMO15successfull
      02.01.2013DEMO5unsuccessfull

       

      Meaning: The number of successfull items will be used as it is, and marked with "successfull" in "Status". The number of "Status" "unsuccessfull" items needs to be calculated (Items_Total - Items_Successfull) and putted into the line.

       

      Any idea how to transform my data source to achieve this?

       

      Thanks already,

      Mathias