topic How to show the bit photo in the QlikView in QlikView

How to show the bit photo in the QlikView

Wed, 06 Jul 2011 03:07:38 GMT

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.

How to show the bit photo in the QlikView

Wed, 06 Jul 2011 04:28:57 GMT

In the expression, change the Representation type to Image.

How to show the bit photo in the QlikView

Wed, 06 Jul 2011 09:27:54 GMT

Sorry, it does not work, could you provide one sample doc to me?

How to show the bit photo in the QlikView

kaushiknsolanki — Wed, 06 Jul 2011 09:48:12 GMT

Hi,

Can you send the Qvw file.

Regards,

Kaushik Solanki

Re: How to show the bit photo in the QlikView

Wed, 06 Jul 2011 10:14:36 GMT

Here is the QVW.

Re: How to show the bit photo in the QlikView

kaushiknsolanki — Wed, 06 Jul 2011 10:25:37 GMT

Hi,

The file is not opening at my side, may be it got currpt,

Please upload a fresh copy.

Regards,

Kaushik Solanki

Re: How to show the bit photo in the QlikView

Thu, 07 Jul 2011 02:08:27 GMT

Hi All,

I have attached my doc, the imagedata is bit, how to show it in pivot table?

Thanks.

Re: How to show the bit photo in the QlikView

kaushiknsolanki — Thu, 07 Jul 2011 06:09:15 GMT

Hi,

I couldnt find anything in qlikview.

There can be two ways to do this.

1. Write vbscript macro which will convert the byte into image and then use it to show in chart.

This is not a good option.

2. Do this conversion at your datasource level, and then fetch that in qlikview.

Regards,

Kaushik Solanki

Re: How to show the bit photo in the QlikView

Thu, 07 Jul 2011 06:18:14 GMT

Hi Kaushik,

You mean QV could not show bit picture that is stored in SQL Server?

Re: How to show the bit photo in the QlikView

kaushiknsolanki — Thu, 07 Jul 2011 06:19:39 GMT

Hi,

Qv can show the pictures but it need to be in image format not in byte.

Regards,

Kaushik Solanki

Re: How to show the bit photo in the QlikView

Thu, 07 Jul 2011 06:22:11 GMT

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.

Re: How to show the bit photo in the QlikView

suresh_rawat — Tue, 30 Jun 2015 07:18:31 GMT

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