1 Reply Latest reply: Jun 14, 2017 5:47 PM by Marco Wedel RSS

    split Multiple dates

    Saima SM

      hi Anil, here is sample data file attached

      each date in each row , 0.5 hrs as new column without hrs, Total:2hrs needs to go I have 60 colums like this having variable no. of entries in one cell . I am working in QlikSense.

         

      2016/05/02: 0.5 hrs
      2016/08/31: 0.5 hrs
      2016/11/21: 0.5 hrs
      2017/02/27: 0.5 hrs
      Total: 2 hrs