Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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);