1 Reply Latest reply: Aug 28, 2012 1:58 AM by Rikab Kothari RSS

    Error while reading values from SharePoint list

      Hello,

                I am trying to read values from a SharePoint list.

      A column named "SubStage" is stored as a single line of text in SharePoint. I would like to map the values of the SubStage column to create a field in QlikView called "Current Sourcing Stage". I want to accomplish this via a QlikView script. Given below is an excerpt of the script in QlikView:

       

       

       

       

      if([Sub Stage] = 'FNL','1FNL'
      ,
      if([Sub Stage] = 'SRC','2SRC'
      ,
      if([Sub Stage] = 'RFQ','3RFQ'
      ,
      if([Sub Stage] = 'QTD','4QTD'
      ,
      if([Sub Stage] = 'FAS_Undelivered', '5FAS'
      ,
      if([Sub Stage] = 'FAS_Development','5FAS'
      ,
      if([Sub Stage] = 'FAS_delivered','5FAS'
      ,
      if([Sub Stage] = 'Production', '6PRD'
      ,
      if([Sub Stage] = 'DNS','6DNS'
      ,
      if([Sub Stage] = 'NIF','0NIF'
      ,
      if([Sub Stage] = 'SSS','7SSS'))))))))))) as [Current Sourcing Stage],

      The above mapping works perfectly fine when I read the "Sub Stage" column from Excel. However, when I read "Sub Stage" from the SharePoint list, the "Current Sourcing Stage" does not get mapped per the above logic.

      Can you please help me understand why this logic does not work when I read values from a SharePoint list?

      Your help is much appreciated!