Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to show hyper link for a field in Qlik Sense Table

Hi Folks,

I have a Table, i need to apply hyper link for one of the field (integer).

Sub2u444

20 Replies
Chanty4u
MVP
MVP

Not applicable
Author

Hi

I read out the post which you are shared in the above. They are using Text and added the URL.

But i am trying to apply the URL in a Table for a particular field.

Sub2u444

reddy-s
Master II
Master II

Hi Subba Reddy,

You will have to go with an extension to achieve this. The table object does not have this option available yet.

Thanks,

Sangram

Not applicable
Author

Hi,

I am new to QS.

Can you share the extension...

Sub2u444

reddy-s
Master II
Master II

Hi Subba reddy,

I am not sure if there is an existing extesnion for it yet. But I can surely assist you in building one.

All you need is <a href="url you need">Dimension value from a Hypercube</a> in a loop.

Thanks,

Sangram Reddy.

Not applicable
Author

No, Its not working.

reddy-s
Master II
Master II

Have you built an extension with the code I added above?

Not applicable
Author

your saying about the below code..

<a href="url you need">Dimension value from a Hypercube</a>


?


It's not working i checked it.

reddy-s
Master II
Master II

Hi Subba Reddy,

Did you create an extesnion? Are you receiving data from a hypercube?

Once done: use code some thing like this:

if ( dimensions && dimensions.length > 0 ) {

  matrix.forEach(function ( row ) {

                 

                  ref_Value = row[1].qAttrExps.qValues[0];

                 

                  if (isNaN(ref_Value.qNum)){

                   

                    if(count < 3){

                    color = "#AAFFA0";

                    count++;

                  }else if (count >= length){

                    color = "#FFDDDD";

                    count++;

                  }else{

                    color = "#FFFFA0";

                    count++;

                  }

                   

                  }else{

                   

                   calVal = ((ref_Value.qNum - row[1].qNum) / ref_Value.qNum)*100;

                    if(calVal < -10){

                    color = "#FFDDDD";

                  }else if(calVal > 10){

                    color = "#AAFFA0";

                  }else{

                    color = "#FFFFA0";

                  }

                   

                  }

                 

                  html += "<div class='selectable hooverable tileDiv' ' data-value='" + row[0].qElemNumber + "' style='background-color:" + color + ";'>";

  html += "<strong>"+row[0].qText+"<br>"+ row[1].qText+"</strong>";

  html += "</div>";

  } );

  }

  html += "</div>";