Error while reading values from SharePoint list

Tue, 29 May 2012 19:18:08 GMT

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!

Re: Error while reading values from SharePoint list

qlikviewforum — Tue, 28 Aug 2012 05:58:43 GMT

Hi Hemanth

Have you managed to load the data from sharepoint which needs authentication. I am trying the same but couldn't managed to get the solution. Please let me know if you have for the solution.

Thanks,

qlikviewforum

topic Error while reading values from SharePoint list in QlikView

Error while reading values from SharePoint list

Re: Error while reading values from SharePoint list