conditonally show link or text in table

[#1]

HI,

In Qlikview table, we can set the representation of an expression as link or text in the expression properties of the chart. Is it somehow possible to conditionally see if the string has a link, then show that as a link, otherwise show it as a non clickable text?

Regards

Shah

[Anonymous]

Hi,

You can create two expression out which one represented as text and other as link.

These expressions can be Conditionally shown/hidden easily...

Hope this works

Regards

Nitin

[MayilVahanan · Accepted solution]

hi

Try like this

=If(Condition, 'Google<URL>'&'WWW.Google.com', TextExpression)

For Example

Year	Test
2010	2010
2011	2011
2012	2012
2013	2013
2014	2014
2015	Google

=If(Year = 2015, 'Google<URL>'&'WWW.Google.com', Year)

[#4]

The problem is that there will be many records. Some of them will be links and some of them will be text. However, your solution will still be showing only one type at a time. So all records will be either text or all records will be links

Shah

[#5]

This looks like it might be the solution I am looking for.

Many thanks both,

Shah

[jonathandienst]

A link must have the structure of displaytext<url>linktext. If you conditionally leave out the "<url>" part, the text will no longer be clickable, even though the representation is set to "Link".

[qlikviewwizard]

Hi Syed,

Please close the thread by selecting Correct Answer and Helpful as you already got the solution. Thank You.