Solved: Re: How to show the bit photo in the QlikView - Qlik Community

Report Inappropriate Content · ‎2011-07-05

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.

Report Inappropriate Content · ‎2011-07-07

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.

View solution in original post

Report Inappropriate Content · ‎2011-07-06

In the expression, change the Representation type to Image.

Report Inappropriate Content · ‎2011-07-06

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

kaushiknsolanki · ‎2011-07-06

Hi,

Can you send the Qvw file.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2011-07-06

Here is the QVW.

kaushiknsolanki · ‎2011-07-06

Hi,

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

Please upload a fresh copy.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2011-07-06

Hi All,

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

Thanks.

kaushiknsolanki · ‎2011-07-07

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2011-07-07

Hi Kaushik,

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

kaushiknsolanki · ‎2011-07-07

Hi,

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!