Vizlib Home Try Vizlib
Welcome
Login
Submit a ticket
  1. Help Center
  2. Vizlib Community
  3. Feature Requests
  4. VizLib Table: Allow Dimesion Text to be treated as URL

VizLib Table: Allow Dimesion Text to be treated as URL

B
Business Intelligence
started a topic over 3 years ago

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
  • S
    Suraj
    said over 2 years ago

    In second step, 'Hide the dimension from view" is mentioned. How to hide a dimension, that is added into Data


  • B
    Business Intelligence
    said over 2 years ago

    Set column width to 0px.

  • C
    Chris Fountain
    said about 1 year ago

    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!

  • Luke Tolchard
    said 7 months ago
    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
    Table with U...
    (192 KB)
  • Luke Tolchard
    said 7 months ago
    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
  • Luke Tolchard
    said 5 months ago
    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
    __Table with...
    (192 KB)
  • M
    Michael Agostinelli
    said 3 months ago

    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

  • B
    Business Intelligence
    said 3 months ago

    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. 

  • H
    Henk de Winter
    said 10 days ago

    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
Topics in this forum
View all

Didn't find what you were looking for?

Start a new topic