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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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.