topic Re: Image Load in QlikView

Image Load

vanderson009 — Thu, 19 Dec 2013 10:32:39 GMT

Hi Communty,

I am using this Script to Load Image in QV,

But still i am facing problem, is thr any wrong with my script??

Players:

Bundle LOAD PlayerId,
                       PlayerName,
                       BirthDate,
                       BirthLocation,
                       [Batting Style],
                       [Bowling Style],
                       Image
FROM D:\Qlikview\Cricketers\CricketDashboard.xlsx
(ooxml, embedded labels, table is Players);

Image Column is path of that pertucular image. By using above script

only PlayerId Column is loaded but others are not.

Please Help me........

Thanks and Regards,

Villyee

Re: Image Load

Anonymous — Fri, 20 Dec 2013 19:47:59 GMT

Here is from Help:

The table must contain two columns only, the first one with the field values

that will form the keys to the information, the second one containing the

information elements, e.g. the file names of the pictures etcetera.

That is,

Bundle LOAD PlayerId,
Image
FROM ...

Re: Re: Image Load

VishalWaghole — Fri, 03 Jan 2014 12:18:43 GMT

Hi Michael,

I have created only two columns, One is for link key and other contains image path.

But still it will not work..

Please find attached images.

and my load script is like :

Bundle LOAD CountryName,

CountryFlag

FROM

(ooxml, embedded labels, table is Sheet1);

This bundle load only loads CountyrName Column not Country Flag.

Please help me.

- Thanks and Regards,

Vishal Waghole

Re: Image Load

rohit214 — Fri, 03 Jan 2014 12:27:08 GMT

Hi,

Have to select the image option in text box(if you are using text box)

thanks

Re: Image Load

Fri, 03 Jan 2014 12:28:19 GMT

Hi visha

did you linked your info load table with another like

INFO LOAD

Country as %C,

Flag

FROM infoloadfile.txt

Client:

LOAD

Country as %C,

CustomerID,

...

From clientFile

then in chart use for "Drapeau" =Info(%C) as expression and use representation = image

you'll get this

Best regards

Chris

Re: Image Load

Fri, 03 Jan 2014 12:29:32 GMT

Hi Anderson

PFA...

Re: Image Load

VishalWaghole — Fri, 03 Jan 2014 12:44:23 GMT

Thanks all of you for your valuable response.

But my probleam is when i tried to load data using bundle load like this;

TEST:

Bundle LOAD CountryName,

CountryFlag

FROM

(ooxml, embedded labels, table is Sheet1);

then only CountryName column gets to be loaded and CountyrFlag is not to be loaded.

I dnt knw why this is happened.

- Regards,

Vishal Waghole

Re: Image Load

Anonymous — Fri, 03 Jan 2014 15:22:48 GMT

This is correct. Only CountryName exists as a field, the image CountryFlag is not a "real" field in the data model.

You have to use CountryName and use "image" presentation.

Regards,

Michael

Re: Image Load

jafari_ervin — Tue, 21 Jul 2015 12:33:39 GMT

Hi Villyee

First of all you should define table with just two column, first column is the name of the image and the second column is the path of the image.

Please try to write your script at the end of your script.