Exporting table as htm file

Mon, 30 Nov 2015 19:57:44 GMT

I have a straight table which I export as an htm file. (I intend to use a macro for this eventually) The problem is that I have an embedded link in one column that should be an active link when the file is opened in a browser.

The issue is that when this column is written out:

'<a href="http://www-tac.company.com/Teams/ks/c3/casekwery.php?Case=' & max(INCIDENT_NUMBER) & '"><' & max(INCIDENT_NUMBER) & '></a>'

It becomes this - note the &Lt; and the " in place of < and "

when I check the htm file.

If I change the < to < and the " to " in an editor it will work as a link when opened in a browser.

I'm assuming that Qlik htm interpreter is changing a " to "

My question is is there any way around this and to make the link show up as code that a browser understands.

Thanks in advance.

Re: Exporting table as htm file

Thu, 03 Dec 2015 05:40:56 GMT

I could not find a workaround in Qlik, so I used this short Python Code to parse the file. It replaces the strings as shown in the code

import fileinput

for line in fileinput.FileInput("testHyperlink14.html",inplace=1):

line = line.replace('"', '"')

print line,

for line in fileinput.FileInput("testHyperlink14.html",inplace=1):

line = line.replace('<', '<')

print line,

for line in fileinput.FileInput("testHyperlink14.html",inplace=1):

line = line.replace('>', '>')

print line,

topic Re: Exporting table as htm file in QlikView

Exporting table as htm file

Re: Exporting table as htm file