Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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
sureshqv
Esteemed Contributor III

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

Not applicable

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

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

reddys310
Honored Contributor II

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

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

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

Hi,

I am new to QS.

Can you share the extension...

Sub2u444

reddys310
Honored Contributor II

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

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

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

No, Its not working.

reddys310
Honored Contributor II

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

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

Not applicable

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

your saying about the below code..

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


?


It's not working i checked it.

reddys310
Honored Contributor II

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

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>";