topic Help required on Image in QlikView

Help required on Image

sayadutt — Fri, 05 Jun 2015 04:38:56 GMT

Hi Team,

I have a requirement where I need to show a image on the sheet. Till now I was doing this by creating Text Object ,selecting Image as Background and uploaded the image. By doing so, the image got embedded into the qvw.

Now my client don't want this image to be embedded. What he is looking for is, storing this image in a centralized location, and giving the location path to qlikview.

By doing so, he can modify the image and save in the same location, without touching qvw. And each time on reload qvw will display the modified image.

Can you please help how to do this. To pass the location path of the image without embedding the image.

thanks

Re: Help required on Image

jonathandienst — Fri, 05 Jun 2015 05:11:27 GMT

You need an info load or bundle info load.Something like

//	Icon file path

SET help_IconPath = '\\Server\Qlikview\Graphics\';

SET help_DataPath = '\\Server\Qlikview\Help_Text_Standard.xlsx';

//	Load the picture id's and descriptions

Help_Icons:

LOAD Picture_ID, Picture_Name, Picture_Category, Client_Type, Picture_Text

FROM '$(help_DataPath)'(ooxml, embedded labels, table is Help_Pictures);

//	Load the pictures

BUNDLE INFO LOAD Picture_ID, '$(help_IconPath)' & [Picture_Name]

RESIDENT Help_Icons;

Search here with the bold text above for more information.

Re: Help required on Image

Fri, 05 Jun 2015 07:10:52 GMT

Hi Syantan,

Yes this can be resolved by the method shared by Jonathan,

To make it more simple and clear please follow below steps;

1).

2. Creat one list box with all country names

3. Creat text object with the expression:

info(Country) and representation should be image...

I hope its helpful

regards

Re: Help required on Image

Fri, 05 Jun 2015 07:13:56 GMT

It will reflect results shown below;

what ever changes you may do in image will reflect in your QV

Re: Help required on Image

sayadutt — Fri, 05 Jun 2015 07:31:49 GMT

Hi Nikhil,

Can you please tell me what should be inside the csv you mentioned?

Just to be more clear on my requirement:

The image i want to display, does not depend on any condition. Its a type of logo which will be always displayed on the sheet.

I just need to make the file location of this logo external, so that if somebody wants to modify the logo, they can do it without opening qvw.

And qvw will pick the modified image.

Can you please give me a sample qvw and what all columns are required in the csv (as mentioned by you)

Thanks

Re: Help required on Image

Fri, 05 Jun 2015 07:33:37 GMT

this file should have the country names with the complete path as shown below;

Re: Help required on Image

Chanty4u — Fri, 05 Jun 2015 08:06:13 GMT

awesome Dixit