How to use a field value of a particular/current record within set analysis to create hyperlink using information from that record

[vvira1316]

Hi,

I've situation where I'm trying to open a document in another application whose web address is available in one of the field within a record. I want to create link only when web address is available in record. I'm having challenge there. Please note I'm able to construct web link but not able to use corresponding record value.

Any help will be highly appreciated.

Thanks,

Vijay

I've included straight table chart with info in it for your reference.

[vvira1316]

I was able to achieve it by creating a dimension with link construct and using it in expression the same way I was doing count for Docs column but with maxstring functionality and Document ID as additional condition in set analysis.

I created the URL Link as dimension while loading data and used it calculated expression in the chart.

Dimension

   If(IsNull([Document URL]),'',[Document ID] & Chr(60) & 'URL' & Chr(62) & SubField([Document URL],'"',2)) as [URL Link],

Expression

=MaxString({ <[Field1]={Value1}, [Field2]={'Value2', 'Value3'},[Document ID]> } [URL Link])