topic Re: conditonally show link or text in table in QlikView

conditonally show link or text in table

Mon, 17 Aug 2015 07:00:22 GMT

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

Re: conditonally show link or text in table

Anonymous — Mon, 17 Aug 2015 07:08:13 GMT

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

Re: conditonally show link or text in table

MayilVahanan — Mon, 17 Aug 2015 07:12:49 GMT

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)

Re: conditonally show link or text in table

Mon, 17 Aug 2015 07:13:42 GMT

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

Re: conditonally show link or text in table

Mon, 17 Aug 2015 07:15:50 GMT

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

Many thanks both,

Shah

Re: conditonally show link or text in table

jonathandienst — Mon, 17 Aug 2015 07:19:39 GMT

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".

Re: conditonally show link or text in table

qlikviewwizard — Mon, 17 Aug 2015 07:20:24 GMT

Hi Syed,

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