topic AW:Re: AW:Qlikview + Sql + image(picture) in QlikView

Qlikview + Sql + image(picture)

Mon, 23 Nov 2009 19:39:30 GMT

Can somebody please tell me how can i use picture like in a sample president.qwv

i m using sql server 2005 as my database.

i will highly appreciate your help guys.....[*-)]

AW:Qlikview + Sql + image(picture)

Tue, 24 Nov 2009 16:16:48 GMT

Hi,

i´ve attached an example which should help to understand how it works.

It doesn´t matter what kind of database you use. The trick is the bundle-load which link external media-files to your data.

Kind regards.

AW:Qlikview + Sql + image(picture)

Tue, 24 Nov 2009 16:54:03 GMT

Can you please try to give an example using Sql server 2005 + qlikview.

I want to see how can i get the path for the picture using sql in qlikview....

AW:Re: AW:Qlikview + Sql + image(picture)

Tue, 24 Nov 2009 17:30:24 GMT

Ah ok, the pictures are saved in the database.

I don´t know exactly, but try something like:


BUNDLE INFO SQL SELECT
Picture, Index
FROM "YOU_DATABASE";

AW:Re: AW:Qlikview + Sql + image(picture)

Tue, 24 Nov 2009 17:58:19 GMT

Please check my attached & tell me what must i do

AW:Re: AW:Re: AW:Qlikview + Sql + image(picture)

Tue, 24 Nov 2009 18:26:55 GMT

You have to add the bundle-load for attaching your pictures. S.th. like this:


BUNDLE INFO LOAD * INLINE [
 Picture_Name, Index
 Events.gif, "YOUR_PATH"\Events.gif
 Income Statement.gif, "YOUR_PATH"\Income Statement.gif
 Statistics.gif, "YOUR_PATH"\Statistics.gif
];

AW:Re: AW:Re: AW:Qlikview + Sql + image(picture)

Tue, 01 Dec 2009 21:07:22 GMT

Thank you, this dialogue was also helped me with some doubts

Re:AW:Re: AW:Re: AW:Qlikview + Sql + image(picture)

Tue, 06 Jul 2010 07:52:29 GMT

Hi,

Do you know how to remove the bundled images??

I removed the code from script editor, and reloded again. But the images still remain..