topic Re: URLS and Null Values in QlikView

URLS and Null Values

brf10043 — Wed, 25 Nov 2020 16:16:04 GMT

All,

I have a column in my data that contains a URL. I am attempting to show "Click Here" in my table which allows the user to click the "Click Here" and then opens the URL. The issue is that there isn't always a value in the column.

My Code is close but I get a “Click Here” when there is no URL. I tried the expression below, but still got a “Click Here” where there was no URL value.

=if(not isnull(Only({< MonthName = {$(vCurrentMonth)},[Q_Vendor Advisory URL] = {*}>}[Q_Vendor Advisory URL])),
'Click here <URL>'&Only({< MonthName = {$(vCurrentMonth)}>}[Q_Vendor Advisory URL])
)

Thoughts?

Re: URLS and Null Values

lironbaram — Thu, 01 Dec 2016 18:01:01 GMT

try this

if (len(Only({< MonthName = {$(vCurrentMonth)}>}[Q_Vendor Advisory URL]))>2,

'Click here <URL>'&Only({< MonthName = {$(vCurrentMonth)}>}[Q_Vendor Advisory URL])
)

Re: URLS and Null Values

brf10043 — Thu, 01 Dec 2016 20:56:40 GMT

Thanks Liron! That worker perfectly!