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: 
Not applicable

(Isnull) (Replace) and (hyperlink)

Hi,

Could anyone please help that what is it not right with following ??? I want to hyperlink these all these images to its appropriate paths in internal source and on wesite too. Is it possible ?

if (IsNull (PATH='http://www.mywebsite.com/images/PriceList/defaultLH.jpg'),

if (WildMatch(PATH,'\\sql_rep\ImageVault\*'),'http://www.mywesite.com/images/PriceList/') & Replace(WildMatch(PATH,'\\sql_rep\ImageVault\*'),'',

if (WildMatch(PATH,'V:\*'),'http://www.mywebsite.com/images/PriceList/') & Replace(WildMatch(PATH,'V:\*'), '',

if (WildMatch(PATH,'\\SQL_REP\IMAGEVAULT*'),'http://www.mywebsite.com/images/PriceList/*') & Replace(WildMatch(PATH,'\\SQL_REP\IMAGEVAULT*'), ''))))

AS NEW;

May anyone help me with that ?

Many thanks

Aamir

4 Replies
Not applicable
Author

Hi Aamir,

Use the Info table to load all these url and then use their key in Qlikview application

How to create Info table. Please see the Qlikview document.

Hope this help,

Anosh

Not applicable
Author

Hi Anosh,

Thanks for the quick reply. I try in that way.

Regards

Aamir

Not applicable
Author

But could you please tell me about the expression it gives me error "Replace takes three parameters" ?

Not applicable
Author

Hi Amir,

Replace takes three parameters:

Replace(s, fromstring ,tostring)

and you are giving only 1 or 2 parameters

Hope this help,

Anosh