topic Re: URLs in QlikView Table in QlikView

URLs in QlikView Table

Fri, 24 Jan 2014 16:55:07 GMT

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.

Re: URLs in QlikView Table

rustyfishbones — Mon, 27 Jan 2014 12:06:31 GMT

I think you are missing a single quote at the end

=SFOpportunity & '<url>youraddress'

Re: URLs in QlikView Table

jvishnuram — Mon, 27 Jan 2014 12:06:50 GMT

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).

Re: URLs in QlikView Table

rustyfishbones — Mon, 27 Jan 2014 12:14:32 GMT

You can say

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

Re: URLs in QlikView Table

sudeepkm — Mon, 27 Jan 2014 12:59:35 GMT

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'

Re: URLs in QlikView Table

Tue, 28 Jan 2014 19:42:36 GMT

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

)