Vizlib Home Try Vizlib
Welcome
Login

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.


3 people like this idea
  • 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!

  • Hi Business,

    Please see this example application I have created.

    You can do this using VIzlib Actions - Learn more here -> https://www.youtube.com/watch?v=vFoYevtgRZo&ab_channel=Vizlib

    In the QVF attached, I have included 2 Vizlib tables (Pivot Table and Table) with actions applied.
    I have also included a way you can achieved the same result but with a Vizlib Button

    NOTE: You need to remove the '=' (Equals sign) from the field once populated; this is something that Qlik controls, not us/Vizlib.

    Please note your unique ticket reference (#6728) and URL https://community.vizlib.com/helpdesk/tickets/6728

    Kind regards,
    Luke T
    Vizlib | Product Manager
    qvf
  • Hi Business,

    As this solution is not suitable, I have gone ahead and made an internal ticket for this task.

    ​There is no current timeframe for this task.

    Please note your unique ticket reference (#6728) and URL https://community.vizlib.com/helpdesk/tickets/6728

    Kind regards,
    Luke T
    Vizlib | Product Manager
  • Hi Business,


    Sorry it has taken a while to get back to you but you will find that this feature already exists.

    When you add a new column to your table or pivot table, add it as a measure and remove the expression i.e. sum(URL) change to URL

    You will then find an option relating to that specific column called Text is URL. Select it and then go to the text in that column will become selectable.

    Please see the example app attached.

    I believe this feature request has now been answered, please can you confirm?

    Please note your unique ticket reference (#6728) and URL https://community.vizlib.com/helpdesk/tickets/6728

    Kind regards,
    Luke T
    Vizlib | Product Manager
    qvf
  • 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?


    image



    Thank you!

Login to post a comment