Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

chris_mccann
New Contributor

Can RTF (Rich Text Format) data be imported into Qlikview and if so how do you make it presentable?

Hello,

I have attached a qvd which has two fields.

QuestionDesc and QuestionID.

QuestionDesc is the RTF field.

It seem to have all the formatting, preceding the actual question.

Can qlikview import RTF if so how do i apply all the formatting applied to it before Qlikview extracts it?

Cheers.

Tags (2)
1 Solution

Accepted Solutions

Re: Can RTF (Rich Text Format) data be imported into Qlikview and if so how do you make it presentable?

The simple answer is: NO

AFAIK text in charts can be formatted using elemntary tags (e.g. like <B> for bold) but that feature doesn't exist in text boxes where your QuestionDesc field would end up eventually. See also this recent discussion: Re: Formatting a portion of text in a textbox

And in any case, QlikView isn't RTF-capable, so it seems that even if the program would support text formatting, you're in for a complex conversion either in the load script (arghhh...) or before turning the data into a QVD.

Best,

Peter

2 Replies

Re: Can RTF (Rich Text Format) data be imported into Qlikview and if so how do you make it presentable?

The simple answer is: NO

AFAIK text in charts can be formatted using elemntary tags (e.g. like <B> for bold) but that feature doesn't exist in text boxes where your QuestionDesc field would end up eventually. See also this recent discussion: Re: Formatting a portion of text in a textbox

And in any case, QlikView isn't RTF-capable, so it seems that even if the program would support text formatting, you're in for a complex conversion either in the load script (arghhh...) or before turning the data into a QVD.

Best,

Peter

Not applicable

Re: Can RTF (Rich Text Format) data be imported into Qlikview and if so how do you make it presentable?

You need to use String functions to cleanse the data. Please find below script for your qvd:

LOAD QuestionID,

     QuestionDesc,

     Trim(Subfield(SubField(QuestionDesc,'\cf0',2),'}',1)) AS NewDesc

FROM RTF.qvd (qvd);

Community Browser