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: 
davyqliks
Specialist
Specialist

If statement for url display name

Hi,

I am displaying a url in a table using the representation 'URL' and want a abel for if there is or is not a link in the data.

I tried the following, but all appear blank

I want to say 'View' if there is a value in the field PDF LINK and No Certificate if the field is empty

this is my effort.

=if(len([PDF link]>0)='View',
'No Cert'
)

 

but as mentioned, i get blank or greyed out.

thanks

DQ

 

 

Labels (1)
1 Solution

Accepted Solutions
GaryGiles
Specialist
Specialist

@davyqliks 

First off, you need a ) after the link function, not the 0:

=if(len([PDF link])>0,'View',
'No Cert'
)

 

View solution in original post

2 Replies
GaryGiles
Specialist
Specialist

@davyqliks 

First off, you need a ) after the link function, not the 0:

=if(len([PDF link])>0,'View',
'No Cert'
)

 

davyqliks
Specialist
Specialist
Author

Hi,

Thanks... i was so close.

Really appreciate your time and assistance.

Thanks

DQ