Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
brf10043
Creator
Creator

URLS and Null Values

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?

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

try this

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

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

View solution in original post

2 Replies
lironbaram
Partner - Master III
Partner - Master III

try this

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

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

brf10043
Creator
Creator
Author

Thanks Liron!  That worker perfectly!