Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Anosh,
Thanks for the quick reply. I try in that way.
Regards
Aamir
But could you please tell me about the expression it gives me error "Replace takes three parameters" ?
Hi Amir,
Replace takes three parameters:
Replace(s, fromstring ,tostring)
and you are giving only 1 or 2 parameters
Hope this help,
Anosh