4 Replies Latest reply: Jun 1, 2014 5:29 PM by Marco Wedel RSS

    Separating arguments from a cell in Excel worksheet upon loading in Qlikview

    Todd Kaiser

      Trying to figure out how to separate arguments within a cell from an Excel spreadsheet upon the load into Qlikview app.  I have attached a sample.  I will need the script rather than the .qvw.  I was familiar with the Peek function when I have data in separate rows.  This question is when the arguments are in the same row.  Here is what I started with for scripting:

       

       

       
      if(len([Dept. #])>0,[Dept. #],peek('1')) as [SAM Dept. #],

       
      if(len([Station / TLID])>0,[Station / TLID],peek('1')) as [SAM Station / TLID],

       
      if(len([Q-note #])>0,[Q-note #],peek('1')) as [SAM Q-note #],

        
      if(len([Dev.Description])>0,[Dev.Description],peek('1')) as [SAM Dev.Description],

          
      if(len([Deviation])>0,[Deviation],peek('1')) as [SAM Deviation Owner],

          
      if(len([Reference ETN])>0,[Reference ETN],peek('1')) as [SAM Reference ETN],

          
      if(len([Material])>0,[Material],peek('1')) as [SAM Material In],

          
      Qty as [Qty In],

          
      Sloc as [Sloc In],

          
      Material1 as [Material Out],

          
      Qty1 as [Qty Out],

          
      Sloc1 as [Sloc Out],

          
      [Dev. Request Status],

          
      [Dev. Start Date],

          
      [Dev. Actual End Date (Q-note closed)],

          
      [NCCA #],

          
      [Decision #],

          
      [Decision effective Date]