Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist III

Need to upload photos in qlikview

Hi All,

I have a requirement is that, Need to upload photos in my qlikview dashboard.

Can any one help me out in getting the same.

Thanks in advance for your support.

Thanks & Regards,

Sasi

10 Replies
Highlighted
Employee
Employee

Re: Need to upload photos in qlikview

I don´t think its possible.

Maybe build another app (Java/Asp.Net/PHP/Rails/...) that will save the pics into a folder QlikView can read

Highlighted
Not applicable

Re: Need to upload photos in qlikview

Hi

This works with "info load" statement

Ex :

INFO LOAD

    Country        as    %N,

     Flag

FROM Data\flags.txt

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

Client:

LOAD

Country as %N

Client,

Country,

...

Best regards

Chris

Highlighted
Specialist III
Specialist III

Re: Need to upload photos in qlikview

Hi thanks for your reply..

Like i am planning to save the photos in some location(Folder), and will try to uplaod the same in qlikview.

By using some selection, take list box value the photo need to get display.

Highlighted
Master II
Master II

Re: Need to upload photos in qlikview

Use bundle load to add images in your dashboard.

For more information you can check qlikview reference manual.

HTH
Susihl

Highlighted
Not applicable

Re: Need to upload photos in qlikview

Hi,

I am looking the same can you please tell me how you are doing.

Highlighted
Not applicable

Re: Need to upload photos in qlikview

As mentioned before you need to do an INFO load in the script first. If you want to save the picture as part of the QVW file, rather than reference it from disk externally, you can do an Info load with the "bundle" prefix.

The artefacts can then be referenced within QlikView objects:

2013-10-24_16h45_33.png

Bundle

The Bundleprefix is used to include external files, such as image or sound files, or objects connected to a field value, to be stored in the qvw file.

If a piece of external information, such as an image or a sound file is to be connected to a field value, this is done in a table that is loaded with the Info prefix. In order to maintain portability, it is possible to include the external files into the .qvw file itself. To this end use the Bundle prefix. The bundled info files are compressed in the process, but will nevertheless take up additional space both in the file and in RAM. Therefore consider both the size and the number of bundled files before going for this solution.

The info may be referenced from the layout as normal info, via the chart info function or as an internal file via the special syntax qmem:// fieldname / fieldvalue alternatively qmem:// fieldname / < index > where index is the internal index of a field value.

The Info prefix may be omitted when Bundle is used.

Bundle[Info] ( loadstatement | selectstatement)

Examples:

Bundle Info Load * Fom flagoecd.csv;

Bundle SQL Select * From infotable;

Highlighted
Specialist III
Specialist III

Re: Need to upload photos in qlikview

Hi,

Will let you if i found any solution.

Thanks & Regards,

Sasi

Highlighted
Specialist III
Specialist III

Re: Need to upload photos in qlikview

Hi thanks for your support,

Will try for the same and get back to  you , if i found any issues.

Highlighted
Creator
Creator

Re: Re: Need to upload photos in qlikview

Hello!

Try this:

INFO

Image_size(360,240)

SQL                   

SELECT ID_PICTURE

              PICTURE

FROM TABLE_PICTURE;

Teste.jpg

IINFO: COMMAND TO READ THE DOCUMENT FILES AND EMBED QLIKVIEW

IMAGE_SIZE (360,240): THIS COMMAND IS OPTIONAL IF YOU WANT PICTURES AND BE ENTERING THE SIZE OF ALL STANDARDIZE

SQL

SELECT

ID_PICTURE: CREATE A PHOTO ID TO, OR MAY BE Rowno ROWNUN SELECTION, SERVE TO FIND THE FILE AFTER

PICTURE: FIELD CONTAINING THE IMAGE FILE OR BEING BUILT

FROM TABLE_PICTURE

Hug!