topic Display image from local disk in QlikView

Display image from local disk

Wed, 03 Aug 2011 12:05:51 GMT

Hi ,

I have an excel sheet. For ex:

ImageExcel.xls

Image Path

Sunflower "C:\ documents and settings \image1.jpg"

Rose " D:\sam\image2.jpg"

Will qlikview read my excel sheet , locate the place on my hard disk as specified under the "Path" columns and display me the image on the sheet?

Please help.

Thanks,
Sam

kaushiknsolanki — Wed, 03 Aug 2011 12:13:56 GMT

Hi,

Please have a look at the example available on your Computer.

You will find this qlikview application at below path in your computer.

C:\Program Files\Qlikview\Example\Documents

The application name is President.

Hope this will help.

Regards,

Kaushik Solanki

Wed, 03 Aug 2011 13:37:45 GMT

try this

BUNDLE INFO LOAD * INLINE [

Image, Path

Sunflower, C:\ documents and settings \image1.jpg

Rose, D:\sam\image2.jpg

];

Sumit

SunilChauhan — Wed, 03 Aug 2011 14:41:44 GMT

try using this

let vNo = peek('Sequence',-1,'Presidents'); // Get current number of Presidents from Presidents table field

for i=1 to $(vNo) // Go to the current number of Presidents

Photos:

load $(i) as Sequence, $(i)&'_150.bmp' as Photo autogenerate(1);

next;

for j=1 to $(vNo)

BUNDLE INFO LOAD * INLINE [

Photo, Index

$(j)_150.bmp, ..\Database\images\$(j)_150.bmp

];

next j;