topic Sharepoint data format issues in QlikView

Sharepoint data format issues

Anonymous — Tue, 28 Feb 2017 14:47:09 GMT

All, I have pulled data from a sharepoint list into Qlikview. However, the format has changed. I am pulling a commentary field and our requirement is to have all bullet points and paragraphs as it appears in the original field. So is it possible to have it in same format in Qlikview as it is in Sharepoint?

Thanks

sam

Re: Sharepoint data format issues

avinashelite — Tue, 28 Feb 2017 14:53:40 GMT

try like this

Text(Field_Name) as Field_Name

Re: Sharepoint data format issues

Anonymous — Tue, 28 Feb 2017 15:07:02 GMT

Actually when I pulled the field, it got the html code along with the data. So applying the text function wouldnt help. I need to remove the html code but at same time maintain the format of the data.

Re: Sharepoint data format issues

avinashelite — Tue, 28 Feb 2017 15:29:52 GMT

Could share the what the data your getting and what you needed so that I could help you out

Re: Sharepoint data format issues

Anonymous — Wed, 01 Mar 2017 17:34:43 GMT

Here is my sample Sharepoint data that I want to export into QV:

Comment

Data as of Jan 2016:

Under Budget
Expenses more than available amount
More people hired

Summary: Status is Green

Data as of Feb 2017:

Over Budget
Expenses more than available amount
Less people hired
Available capital more than allowed limit

Summary: Status is Red

I want the Comment data to be shown in exact format(bold, underline, bullets,etc) as above in QV.

Thanks so much!