Planned
VizLib Table: Allow Dimesion Text to be treated as URL
The standard Qlik table allows dimensions to be URL. For VizLib table, it takes several more steps to replicate this behaviour:
- Create a dimension
- Hide the dimension from view
- Create a measure using the same expression/field as the dimension
- Set text type as URL
It's counter-productive to have to do additional steps to make the same happen in VizLib table as compared to the single step in the standard Qlik table. VizLib plugin should be better than the standard, not worse.
In second step, 'Hide the dimension from view" is mentioned. How to hide a dimension, that is added into Data
Set column width to 0px.
Hello,
Please add this feature. Adds a huge amount of functionality if your ticket list can link to the actual ticket in that application.
Thanks in advance!
Please note your unique ticket reference (#6728) and URL https://community.vizlib.com/helpdesk/tickets/6728
Please note your unique ticket reference (#6728) and URL https://community.vizlib.com/helpdesk/tickets/6728
Please note your unique ticket reference (#6728) and URL https://community.vizlib.com/helpdesk/tickets/6728
Hi Luke, thanks for posting the workaround. However this solution is not ideal as creating hyperlinks from measures will, as far as I can see, prevent you from searching, sorting and selecting values within the measure/field. Adding the URL feature within the dimension would be a useful addition. Thanks, Michael
Hi Luke,
The work-around that you propose is exactly what has been described in the original post. This is not what we want! I agree with Michael that it would be super useful to be able to display a *Dimension* as a URL and not only a measure. As pointed out in the original post, this feature is available in the plain Qlik Sense table and Vizlib add value instead of taking away functionality.
Thanks and regards.
Hi all,
I have created vizlib table and added the action "Open Url" from a dimension called: DIMENSION_FROM_TABLE
I have added ='http://xxx'&DIMENSION_FROM_TABLE&'xxx.com'
When openening the report I can click the link and it works perfectly. When exporting this to excel the url is no longer working, it shows the result and not a clickable link.
I have also changed the font color and added an underline, so the text looks like a link in the report. This layout is also copied to excel.
Any idea how to export this report to excel having the url also clickable in excel?
Thank you!