topic Re: How to insert HTML tags in HTML reports by variable in Qlik NPrinting

How to insert HTML tags in HTML reports by variable

MarcoRaymundoKeyrus — Tue, 17 Mar 2020 20:40:38 GMT

Hi!

I want a generate list like this:

Apple
Banana
Orange

I created a variable to include a message in the body of the email.
SET vList = = Concat (Aggr ('<li>' & MYFIELD & '</li>', MYFIELDAGGR));

In the HTML report, I created the following structure:
<ul> %% vList %% </ul>

In NP 16 it worked perfectly, generating the list, like above.

In NP 19 april, in the output file, the tags <li>;</li>, were converted to <li</&

Does anyone know how to prevent NP when generating the HTML file to do this conversion?

Re: How to insert HTML tags in HTML reports by variable

Frank_S — Fri, 29 Nov 2019 17:08:42 GMT

@MarcoRaymundoKeyrus

Try this. If you use the variables inside the report itself using the list tags it works :

<html>
<body>
<ul>
<li>%%vQuarterMinusTwo%%</li>
<li>%%vHyperlink%%</li>
<li>%%vSalesman%%</li>
</ul>
</body>
</html>

Re: How to insert HTML tags in HTML reports by variable

MarcoRaymundoKeyrus — Tue, 03 Dec 2019 14:58:18 GMT

Thanks Frank!

Your approach solves when the variable results in a row.
My variable results in more than one line, something like:
=Concat (CITY, ',') -> City_1, City_2.
I need to use show the result as an HTML list using the <ul> <li> tags.
I tried with the variable (qlikview) and as an expression (nprinting), in both nprinting converts the characters "<,>" into their respective special codes: "<,>".
As a result the tags are not interpreted.

Try this: In HTML report, Create a nprinting expression ='<b>BOLD TEXT</b>'. Show the report.

I believe that in NP 16 there was no conversion of expressions and variables before inserting them in the html report. That apparently in NP 19 this conversion occurs.

Re: How to insert HTML tags in HTML reports by variable

Frank_S — Tue, 03 Dec 2019 18:33:30 GMT

Hi @MarcoRaymundoKeyrus

Can you do what I did and show your work using snapshots?

Show an NP 16 (working example) and NP 19 (not working example) or visa versa.

I'm not sure I am following completely at this point any longer.

Detail steps to reproduce the issue and snapshots will help me to visualize what you are experiencing here. Also show how it was working in the past.

Thanks.

Re: How to insert HTML tags in HTML reports by variable

MarcoRaymundoKeyrus — Tue, 03 Dec 2019 21:35:38 GMT

Follow the steps:

This is my variable in the qvw file:

This my html report (NP19 april):

Report generated:

Report generated (code):

The qvw file, expression, and html report are the same as I used with NP16. Which rendered the report "correctly".

Re: How to insert HTML tags in HTML reports by variable

Frank_S — Tue, 03 Dec 2019 22:24:54 GMT

Hey @Ruggero_Piccoli

Can you have a look at this situation?

Re: How to insert HTML tags in HTML reports by variable

Lech_Miszkiewicz — Tue, 03 Dec 2019 22:44:30 GMT

This seems to behave as designed.. all objects (except table) use html encoding

If you want to pass text (without encoding) you may want to create a straight table, put your variable in it and use it as a source. In NPrinting desigenr table properties you would have an option to turn on/off encoding.

cheers

Re: How to insert HTML tags in HTML reports by variable

MarcoRaymundoKeyrus — Wed, 04 Dec 2019 11:26:21 GMT

I tested your tip and it worked.

Thank you!

Re: How to insert HTML tags in HTML reports by variable

MarcoRaymundoKeyrus — Wed, 04 Dec 2019 11:31:34 GMT

@Frank_S

Thank you for your attention and help, they were instrumental in solving my problem.

Hugs!

Re: How to insert HTML tags in HTML reports by variable

Ruggero_Piccoli — Wed, 04 Dec 2019 11:52:37 GMT

Hi,

I did many tests this morning and the only way that I found that works (in the meaning that < and > are kept and not replaced) is by inserting them directly in the HTML code of the template.

I tested variables, formulas and straight table columns. In all cases the < and > are replaced and the report will be not correct.

The workaround could be to create a straight table with the content of the formula without the <li> in a column, add that table in the Levels node and add the <li> tags directly in the template.

Best Regards,

Ruggero

Re: How to insert HTML tags in HTML reports by variable

MarcoRaymundoKeyrus — Wed, 04 Dec 2019 12:15:07 GMT

@Ruggero_Piccoli

Thank you!
I tested your tip and it worked correctly.
I think it's a good technique to keep HTML code more flexible and easy to understand.

This information is very useful.

Congratulations!

Re: How to insert HTML tags in HTML reports by variable

Lech_Miszkiewicz — Wed, 04 Dec 2019 12:39:28 GMT

Hi @Ruggero_Piccoli

i think this should be discussed with R&D as lack of compatibility between v16 and 17+.
If values of variables, formulas etc are passed on template differently in those versions then any attempt of migration will not be successful. Ehat do you think?

thanks

lech

Re: How to insert HTML tags in HTML reports by variable

Ruggero_Piccoli — Wed, 04 Dec 2019 13:18:48 GMT

Hi,

Yes, it could be a problem for a migration, but, maybe, the wrong way of working is the one of QlikView NPrinting 16. I mean if the content of a QlikView variable is placed in the HTML report without any "analysis" it could contain a script that will be executed. So it must be managed carefully.

In any case, the R&D is aware of this behaviour 🙂

Ciao