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

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

Tue, 05 Apr 2016 07:08:40 GMT

Hi Folks,

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

Sub2u444

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

Chanty4u — Tue, 05 Apr 2016 07:11:13 GMT

chk dis

Hyperlink in Qliksense

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

Tue, 05 Apr 2016 07:26:13 GMT

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

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

reddy-s — Tue, 05 Apr 2016 13:02:05 GMT

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

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

Tue, 05 Apr 2016 17:11:36 GMT

Hi,

I am new to QS.

Can you share the extension...

Sub2u444

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

reddy-s — Wed, 06 Apr 2016 08:45:25 GMT

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.

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

Wed, 06 Apr 2016 09:02:11 GMT

No, Its not working.

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

reddy-s — Wed, 06 Apr 2016 09:07:05 GMT

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

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

Wed, 06 Apr 2016 09:26:31 GMT

your saying about the below code..

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

It's not working i checked it.

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

reddy-s — Wed, 06 Apr 2016 10:13:21 GMT

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

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

Wed, 06 Apr 2016 15:11:46 GMT

Hi,

i am new to qlik sense. I have no idea how to create extension.

can i use the above code in expr?

Thanks for your reply.

SUb2u444

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

reddy-s — Thu, 07 Apr 2016 09:31:05 GMT

Hi Subba Reddy,

I am sorry if I was not clear. You cannot use this in an expression. This cab be used in an extension object in the Javascript file.

Thanks,

Sangram.

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

Thu, 07 Apr 2016 11:34:30 GMT

Okay. Sorry to say, I have no idea in java.

Thanks for your time.

Thanks a ton.

Sub2u444‌

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

reddy-s — Thu, 07 Apr 2016 11:38:38 GMT

No Problem at all!

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

Thu, 07 Apr 2016 11:54:32 GMT

Hi Sangram,

can you the expr, i am not getting he correct color....

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

Chanty4u — Thu, 07 Apr 2016 11:57:27 GMT

r u getting expression error? if yes i think u missed one closing brace at the end.

if not

try with original RGB() values for Green() and Red()

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

Thu, 07 Apr 2016 12:03:18 GMT

so can you share the values for Green and Red..?

i have not getting for above expr, but it was showing expected the color ..

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

Chanty4u — Thu, 07 Apr 2016 12:07:21 GMT

based on ur metrics...u can chk RGB values like below try this

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

Thu, 07 Apr 2016 12:12:30 GMT

I am sorry, i am using QliSense. Here there is no option to select.

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

reddy-s — Thu, 07 Apr 2016 12:17:56 GMT

Hi Subba Reddy,

What Chunty suggested will work even in qliksense. Just make use of the rgb() function like this:

Taking the rgb values from the above screen shot:

use this as the colour code: rgb(255,128,128) this should give you a solid red colour