Load remarks from Excel

[shahamel]

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

[jvitantonio]

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

[shahamel]

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

[jvitantonio]

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)