Discussion Board for collaboration related to QlikView App Development.
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,
This works with "info load" statement
Country as %N,
(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);
Country as %N
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.
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:
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)
Bundle Info Load * Fom flagoecd.csv;
Bundle SQL Select * From infotable;
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
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