Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
CraigF
Contributor
Contributor

Sharepoint Multi checkbox List field issue

Hi everyone

if anyone has any ideas about how to resolve the following please:

I am pulling data from a Sharepoint site

there are a few fields which are set up as Checkboxes and these fields can be multi select e.g. the country field

If i pull this field into Qliksense in a normal load, the country field is displayed as "SYSTEM.String[]"

Table1:

LOAD
ID,

FIELDNAME AS COUNTRY

FROM SHAREPOINT SITE;

RESULTS

ID COUNTRY 

1 SYSTEM.String[]

-----

 

I am trying to resolve this by using SubField() function in the LOAD Script

e.g. 

Table 2:

LOAD
"ID",
Subfield(Country,','1) as CountrySplit

however it looks like the field is being brought through with all values as SYSTEM.STRING[] so this subfield doesnt work, and if i do a SubStringCount('[') it will return 1 as it picks up the bracket

 

any ideas how i can get the country to  display or be brough back as a country list e.g. one of the values is italy,UK,USA?

 

thanks very much

Labels (1)
0 Replies