26 Replies Latest reply: Jun 15, 2017 10:25 AM by Saima SM RSS

    Split multiple dates from one cell into separate rows/records- Qlik Sesnse

    Saima SM

      Hi,

       

      is there any way to split multiple dates from each cell and produce corresponding records.

      E.g in row given below I want one date in one single row. This is very critical for me. Please Help

         

         

      49$10,634.96 2016/09/17: 0.5 hrs
      Total: 0.5 hrs
      2016/09/29: 1 hrs
      Total: 1 hrs
      2016/09/28: 2 hrs
      Total: 2 hrs
      2016/04/22: 0.5 hrs
      2016/06/20: 0.5 hrs
      2016/10/11: 0.5 hrs
      Total: 1.5 hrs

         

      Thanks