topic Re: Load remarks from Excel in QlikView

Load remarks from Excel

shahamel — Fri, 09 Mar 2012 09:06:51 GMT

Dear Users,

I have an Excel-file. I would like to load the remarks from Excel to Qlikview. To make it more clear. I have a student 'Marianne' and the remark is a picture. My aim is to load that picture. If i can load that picture, i can select her name in my Qlikview file and i will be able to see her picture as loaded from the remarks in Excel.

I added the Excel-file.

Many thanks for any answers

Gr. Sandeep

Re: Load remarks from Excel

jvitantonio — Fri, 09 Mar 2012 14:26:30 GMT

Hi, here's the application. Make sure to place both pictures in C:\

Load remarks from Excel

shahamel — Fri, 09 Mar 2012 14:34:25 GMT

Dear Qlikuse14,

I hope it is not to much to ask, but i am without alicence. Would you be so kind to copy / past your used code?

Gr. Sandeep

Load remarks from Excel

jvitantonio — Fri, 09 Mar 2012 14:39:09 GMT

Data:

LOAD * INLINE [

Num, Name

1, Peter

2, Maria

];

Bundle LOAD * INLINE [

Num, Photo

1, C:\homer1.bmp

2, C:\homer2.bmp

];

Then add a list box with the field Num.

Then put a Text box object. Go to properties and put "Representation: Image"

on the formula put =Info(Num)