Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
puttemans
Specialist
Specialist

External link in chart - multiple possibilities

Dear all,

Does anyone know how to tackle the following :

I have a table (chart type) with information, and for more details. I've put a link in this table that should direct users towards a pdf-document that is opened from the server.

My expression to find the file is the following :

= 'BNX'& '<URL>'&vMapPath&'BNX\'&date(date#(SEND_DATE, 'dd/mm/yyyy'), 'yyyy-mm-dd')&' _ BNX-'&BULL_SHORTNAME&'-'&(if(BULL_VERSION < 10, '0'&BULL_VERSION, BULL_VERSION))&' (INFRABEL).pdf'

An example of the filename is : '2017-10-26 _ BNX-65M-55390-01 (INFRABEL).pdf'

I run into 2 similar problems, that is that at the end, between the brackets, there can be 'INFRABEL', but also 'SNCB_NMBS'. Additionally, the send date may vary with 1 day.

So the above example may be '2017-10-25 _ BNX-65M-55390-01 (SNCB_NMBS).pdf' or 2017-10-25 _ BNX-65M-55390-01 (INFRABEL).pdf' or 2017-10-26 _ BNX-65M-55390-01 (SNCB_NMBS).pdf' as well. The middle will always stay the same.

Is there a way within Qlikview to write the expression in such a way that any of these 4 file will be found on the server and opened in the application (without multiplying the links by 4)?

Thanks in advance,

Johan

3 Replies
Anil_Babu_Samineni

Are you getting to get FRABEL and SNCB_NMBS in separate field?

Perhaps this?

TextBetween(FieldName, '(',')')

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
cristinapo
Contributor III
Contributor III

Out of the four possible names of the link, is it just one the correct one? or can there exist more than one valid link for that month?

puttemans
Specialist
Specialist
Author

Hi Cristina,

There is only 1 document available with 1 of the 4 names. I guess I need some kind of loop in the definition of the link, but don't know whether that's possible.