topic Re: Queries on Bundle Info Select in QlikView

Queries on Bundle Info Select

Mon, 16 Mar 2015 10:26:11 GMT

Hi,

I have loaded images from database to QVW through Bundle info select.

Since it is having huge data, it is taking long time to reload and save.

Could You suggest any method to overcome this.

Warm Regards,

Joshmi

Re: Queries on Bundle Info Select

Gysbert_Wassenaar — Mon, 16 Mar 2015 10:36:22 GMT

Load smaller images. Use a graphics tool to down scale the images to a smaller size and perhaps to a better compressible format too.

Re: Queries on Bundle Info Select

Mon, 16 Mar 2015 10:54:45 GMT

Hi Gysbert,

Thank You for Your Reply...

Since we are having read only access to database, We can't edit or compress the image.

Is there any method for re sizing the image after reloading to qvw?

Regards,

Joshmi

Re: Queries on Bundle Info Select

Gysbert_Wassenaar — Mon, 16 Mar 2015 11:00:02 GMT

No. Once the binary blobs are in the Qlikview document they cannot be edited.

Re: Queries on Bundle Info Select

stigchel — Mon, 16 Mar 2015 11:09:23 GMT

Not after loading, but maybe you can try to load them with the following statement

Image_size

This clause is used with the Info prefix to resize images from a database management system to fit in the fields. Width and height are specified in pixels.

Example:

Info Image_size(122,122)Select ID, Photo From infotable;