How to show the bit photo in the QlikView

[#1]

Hi All,

I want to show the photo in the pivot table, the SQL clause:  select t memberid, imagedata from table.

The imagedata is bit not URL or Photo name.

How to show it in pivot table?

Thanks.

[#2 · Accepted solution]

Hi Isaac,

First, you need to use ODBC connection instead of OLEDB. QlikView can only read the BLOB data through ODBC.

Next, you need to use the INFO + Bundle load statement to load the image data into QlikView. Please refer to my QVW (I've downloaded it, and can open. Not corrupted.)

For showing the image, you can refer to the chart.

[suresh_rawat]

Hi Kaushik,

Good Day,

Can you please confirm me,  now is there any functionality in QV to upload bit images from databases.

Please reply as soon as possible basis.

Regards

Suresh Rawat