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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
1600eads
Contributor III
Contributor III

disallow link on dimension if it matches a value

I am creating a dimension on a table for users to hit a url/link. I have a it set up as a dimension, representation = link, and using the link label to do some dynamic labeling on the table. 

I have a Flag dimension that I am using to control the labeling on this column.

if(FLAG_DIMENSION = 'Yes', 'google.com',

if(FLAG_DIMENSION = 'No', null()))

When this duimension is 'Yes' the link label works well and displays 'google.com' like I want. But for some reason, when it is set to 'No' at the 2nd if statement, the return value is not a null value but instead the full link which I am a bit confuse on the behavior, it also allows for users to select that which I do not want. Instead I'd want to disallow the link selection which I thought the null() would handle.

Any guidance, tips, are welcomed! Thank you.

 

Labels (2)
2 Replies
Clement15
Partner - Specialist
Partner - Specialist

Hello,

Can you try this formula?

if(FLAG_DIMENSION = 'Yes', 'google.com',' ')

The user will not be able to click on the link, but he will still be able to filter on this field. I don't think it is possible to prevent this.

1600eads
Contributor III
Contributor III
Author

There was something going on in our qlik instance and after a reset on the server it seemed to fix the issue.