topic How to use a link field in a pivot table? in QlikView

How to use a link field in a pivot table?

Anonymous — Wed, 15 Feb 2017 18:08:52 GMT

Hi,

is it possible to use a link expression in a pivot table?

I enable the subtotals but I am not seeing the value just the name of the field and below the total word.

If I use straight table there is not any issue. The problem is that I have multiple records related to the main one, so the same code will appear like 10 instead of just one (if I use the pivot table).

Please advise.

Re: How to use a link field in a pivot table?

Gysbert_Wassenaar — Wed, 15 Feb 2017 18:15:17 GMT

Can you post a small example that makes clear what you want? I have no idea what you mean with 'a link expression'

Re: How to use a link field in a pivot table?

Anonymous — Wed, 15 Feb 2017 18:56:25 GMT

Sure, in the straight table you can add an expression to looks like a url and that url may open a web site.

If I used it in a straight table I get something like this:

But in a pivot table I should see only one record instead of 3 equals (I cannot use a distinct, I need to use all the records).

In the pivot table that expression will be added to each record that exists related to the Test ID, is there a way that only display one record as the Test ID?

Please let me know if you have further questions and I will try to answer them.