Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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!

1 Reply
qlikviewforum
Contributor II

Re: Error while reading values from SharePoint list

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

Community Browser