Image Load

[vanderson009]

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

[Anonymous]

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 ...

[VishalWaghole]

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

[rohit214]

Hi,

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

thanks

[#5]

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

[#6]

Hi Anderson

PFA...

[VishalWaghole]

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

[Anonymous]

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

[jafari_ervin]

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.