URL issue in table in Mashup API- qliksense

[Anonymous]

Hi I am creating table in mashup though API and qlik visual tag.

like below 

Dim A	Measure1	Measure 2
AAA	10	12

if user click on 10 then he should navigate to different application(i.e 10 should contain https://abcd.net link).

I am not able to populate URL(https://abcd.net ) on 10.

is there any api where i can give hyperlink definition.

Sample code (html) :

<div class="col-sm-12 " id="QV01" style="Height:500px;">
<qlik-visual appid="abc"
type="table"
cols='[
{
"qDef": {
"qFieldDefs": [
"DimA"
],
"qFieldLabels": [
" DimA"
],
"qSortCriterias": [
{
"qSortByLoadOrder": 1
}
]
}
},
{
"qDef": {
"qLabel": "Measure2",
"qDef": "Count(Product)",
"representation":
{ "type": "url",
"urlLabel":""
}
}
},
{
"qDef": {
"qLabel": "Measure2",
"qDef": "Sum(Sales)"
}

}


]'
options='{
}' >
</qlik-visual>

[harithadogiparthi505]

Any workaround for the above question? Please help  me. I am facing similar issue.

[Christopher_prem_]

Hi, 

      I don’t think URL representation is  available for the measure columns, as far as I know, it is only supported for the dimension columns

For measure columns, you can only show a value (Text) or an indicator (Indicator) or a Mini chart (Mini chart) or an Image (Image), but they are not clickable links

Please check:

1. https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Visualizations/Table...
2. https://community.qlik.com/t5/App-Development/Qlik-Sense-URL-Hyperlink-in-Straight-Table/td-p/887696
3. https://community.qlik.com/t5/New-to-Qlik-Sense/URL-Link-in-Table/td-p/1525959

So the workaround is to have the "Dim A" Dimension column value as a clickable link with a URL generated using expressions.

Hope that helps. 

[Christopher_prem_]

Hi,

I don’t think URL representation is  available for the measure columns, as far as I know, it is only supported for the dimension columns

For measure columns, you can only show a value (Text) or an indicator (Indicator) or a Mini chart (Mini chart) or an Image (Image), but they are not clickable links

Please check:

1. https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Visualizations/Table...
2. https://community.qlik.com/t5/App-Development/Qlik-Sense-URL-Hyperlink-in-Straight-Table/td-p/887696
3. https://community.qlik.com/t5/New-to-Qlik-Sense/URL-Link-in-Table/td-p/1525959

So the workaround is to have the "Dim A" Dimension column value as a clickable link with a URL generated using expressions 

Hope that helps.

[ajaykakkar93]

Hi,

We can do this by creating an HTML table on the fly with a new column where it defines if the value is A then the URL as string,

Now you can create a dynamic table in your mashup JS file which will have the data pages for your dimension & measure as well the links as string, That URL can be added on every ROW/CELL with an encore tag <a href=".." target="_blank" />
the above solution is working in my domain perfectly well.