topic (Isnull) (Replace) and (hyperlink) in QlikView

(Isnull) (Replace) and (hyperlink)

Fri, 18 May 2012 05:28:18 GMT

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

(Isnull) (Replace) and (hyperlink)

Fri, 18 May 2012 06:02:06 GMT

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

(Isnull) (Replace) and (hyperlink)

Fri, 18 May 2012 06:09:28 GMT

Hi Anosh,

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

Regards

Aamir

(Isnull) (Replace) and (hyperlink)

Fri, 18 May 2012 06:16:24 GMT

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

(Isnull) (Replace) and (hyperlink)

Fri, 18 May 2012 06:28:31 GMT

Hi Amir,

Replace takes three parameters:

Replace(s, fromstring ,tostring)

and you are giving only 1 or 2 parameters

Hope this help,

Anosh