topic Re: Writing text from a line as an html file in QlikView

Writing text from a line as an html file

Fri, 24 Mar 2017 14:08:54 GMT

Hello,

I would like to download from the selected row/rows (by user) the value from the field (html code) and then save it to a file and after that open it as a web page.

I know that I need to write a macro but I can not do this.

A	html code	save
A	<code>A piece of computer code</code>	save
B	<code>A piece of computer code 2 </code>	save

Regards

Re: Writing text from a line as an html file

hector_munoz — Fri, 24 Mar 2017 15:49:44 GMT

Hi Paula,

Try something the following:

T1:

LOAD * INLINE [

A, html code, save

A, <code>A piece of computer code</code>, save

B, <code>A piece of computer code 2 </code>, save

];

T2:

LOAD [html code] AS '<!DOCTYPE html>'

RESIDENT T1;

STORE T2 INTO .\html.html (txt);

After this, open the HTML file created.

Regards,
H

Re: Writing text from a line as an html file

Mon, 27 Mar 2017 04:51:33 GMT

Hi,

Thank you for your answer.

Unfortunately, not exactly what I meant.

When I click on 'save', I just want to save the code and then display it on the screen.

Re: Writing text from a line as an html file

hector_munoz — Mon, 27 Mar 2017 06:54:38 GMT

Hi Paula,

Do you mean you want to extract data forma an HTML format?

Regards,

Re: Writing text from a line as an html file

Mon, 27 Mar 2017 06:58:42 GMT

Hi Hector,

I want to save the code <html> from the line as a .html file and then open it on the website.

Regards

Re: Writing text from a line as an html file

hector_munoz — Mon, 27 Mar 2017 09:05:26 GMT

OK,

Then I would look for in the Qlik Community for pieces of macros that:

Read the values of a table box (e.g Macro - Loop Through Table)
Write them into a file (e.g. Writing to a text file | Qlik Community)

Regards,

Re: Writing text from a line as an html file

marcus_sommer — Mon, 27 Mar 2017 11:43:03 GMT

Maybe you could use an extension like: QlikTip #39: Displaying Html content within QlikView (Minimalistic HtmlTextBox Object Extension).

- Marcus

Re: Writing text from a line as an html file

Wed, 29 Mar 2017 10:32:03 GMT

Thank You all for your help.

In Qlikview there are two built-in macros, 'Export' and 'Open URL', they were enough to solve my problem.