Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
jasonseril
Contributor

Parse/Convert text of Text Object into qvw Object data

Hello all,

I would like to know if there's available macro that converts/parses text from Qlikview Text Object into object (table, charts..) data?

thanks in advance. cheers.

jason

2 Replies
jasonseril
Contributor

Parse/Convert text of Text Object into qvw Object data

another inquiry, can we use regex to parse XML-format text and get the data? Below is the example XML-format text:

<Forecast>
<Date>2010-03-12T00:00:00</Date>
<WeatherID>4</WeatherID>
<Desciption>Sunny</Desciption>
<Temperatures>
<MorningLow>22</MorningLow>
<DaytimeHigh>50</DaytimeHigh>
</Temperatures>
<ProbabilityOfPrecipiation>
<Nighttime>00</Nighttime>
<Daytime>00</Daytime>
</ProbabilityOfPrecipiation>
</Forecast>2054120


if so, really appreciate if somebody could provide an example or the regex pattern for the above text. Thanks

jason

Not applicable

Re: Parse/Convert text of Text Object into qvw Object data

holaaaa!! ME podrían decir como convierto archivos de XML a QVW??, no se si en qlikview tenga la opción y con alguna otra herramienta para importar los archivos de xml a qlikview

hi! ME could say as I convert XML files to qvw?, Not if you have the option in qlikview and some other tool to import xml files to qlikview