URLs in QlikView Table

[#1]

I am familiar with the Representation type of Link when using an expression. My problem, however, is that I can’t find the right way to apply set analysis to the expression I am using to create the link. When I use the following expression:

=SFOpportunity_Name&'<url>https://na4.salesforce.com/'&SFOpportunity_Id

and outputting it as a link, the table is returning every single Opportunity record in our data model. However, I can’t figure out the right way to apply set analysis here to limit my Opportunity records.

Thanks in advance for any suggestions.

[rustyfishbones]

I think you are missing a single quote at the end

=SFOpportunity & '<url>youraddress'

[jvishnuram]

Hi Tom,

Your requirement is doable you need to store the url in the back end and in the expression you can use only() function with set analysis.

Say for an exmpl in the back end you are saving this url(https://na4.salesforce.com/'&SFOpportunity_Id) as DOWNLOAD

then in the front end Only({<Flag={'S'}>}'<url>'&DOWNLOAD).

[rustyfishbones]

You can say

IF(SFOpportunity = 'Whatever', SFOpportunity ) & '<url>youraddress'

[sudeepkm]

can you pls mention what expression you want to add. Set expression can be applied in an aggregation function.

for example given below will show the sales value only for North America region along with the URL

sum({<Region={'NORTH AMERICA'} >}Price)&'<URL>http://google.com'

[#6 · Accepted solution]

Thanks for all of your suggestions. In case I did not explain the use case well enough, I needed to limit a data set within a table component to only a certain series of Salesforce Opportunity records, and I wanted the results in the table to show the record name as a hyperlink to its SF record.

Here is what I ended up with, and it's working:

=Concat(

       {$<

            MY SET ANALYSIS HERE

       >} SFOpportunity_Name

     )

&'<url>https://na4.salesforce.com/'&

Concat(

       {$<

            MY SET ANALYSIS HERE

       >} SFOpportunity_Id

     )