topic Representation: link (wrong link) in QlikView

Representation: link (wrong link)

Thu, 30 Sep 2010 10:29:23 GMT

Dear sirs,

I am using a straight table, where one of the expressions is being represented as a link (a filename of a scanned document)

However, when I click on any of the links, my qlikview launches the link from the cell BELOW the one I clicked on?? If only one record is shown in the straight table, the link doesnt work at all.

Have you experienced the same? And do you have a solution? Thx in advance.

Jesper Juul (QV 9.0)

Representation: link (wrong link)

Fri, 15 Oct 2010 10:41:18 GMT

bump

Representation: link (wrong link)

Fri, 15 Oct 2010 13:23:45 GMT

Hi Jesper,

I have created a similar hyper link using a straight table (QV 9.00 SR 4 & 5) and it works fine. You might have to consider your expression or try changing it in a pivot table and see if it is has the same behavior.

My Expression:

if(num(Date(trim(CRE_DATE),'DD/MM/YYYY')) >= Num(Date(trim(vMinCreateDate),'DD/MM/YYYY')) and num(Date(trim(CRE_DATE),'DD/MM/YYYY') <= Date(trim(vMaxCreateDate),'DD/MM/YYYY')),
Licenses_Desc &
'<url>http://10.157.xx.xx:8090/omnidocs/searchdocs.jsp?Module=Customer&Index=CustomerID&Value='& CUSTOMER_ID & '&limit=0' )

Representation: link (wrong link)

Fri, 15 Oct 2010 13:30:08 GMT

Thanks.

I tried to convert to pivot table = it worked.
The expression is good, the problem exists only in straight tables. Weird.

Jesper