Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

if a file exist on the web server type "Yes"... How?

Dear Experts,

I am developing a web site... An in a folder there are more than 100.000 product image files (jpeg)   (So I cant use LOAD fonction... I dont want to bussy server )

http://www.test.com/products/images/xxx.jpg    (Front image)

http://www.test.com/products/images/xxx_r.jpg    (Rear image)

On my Desktop:

I am conneting to SQL and Loading ; imagepath  field....

sample data is : /products/images/x.jpg

I can see the rear of this image in qlikview : =('http://www.test.com'&left(imagepath,3)&'_r.jpg')

MY PROBLEM :

time to time I live a problem : Product and its information is on the web but it hasnt any jpeg files. So it isnt good. I want to find products without image file. then I can sent the jpeg files using ftp...

My Stock Code also xxx (same as jpeg file name)

So I want to check filesize or file name on the web but I didnt do.

I wrote a script

Set vSKUSize = FileSize('http://www.test.com'&left(Imagepath,3)&'._r.jpg');

Then I want to use it

if(vSKUSize>0, 'Photo Exist', ''Photo None')  But I dont...

Any Help Please

Kind Regards

0 Replies