topic Re: how to insert image in textbox. in QlikView

how to insert image in textbox.

Tue, 11 Jun 2013 09:11:31 GMT

Hi guys ,

plz find the attachment.

I have an excel file having filelds imgID,Location containing 3 images and there location.
After loading i get two fields imgID and location.

Now i want to use textbox to display image after cliking in ImgID listbox.

Plz help me how to get an image in textbox.

Thanks

Hitesh

Re: how to insert image in textbox.

rajni_batra — Tue, 11 Jun 2013 09:38:16 GMT

Use INFO load in the script ,

then in text object Check Representation as Image and use expression Info(ID).

Hope his helps!!!

Regards,

Re: how to insert image in textbox.

Tue, 11 Jun 2013 09:50:39 GMT

please send me the qvw file?

Re: how to insert image in textbox.

Tue, 11 Jun 2013 09:57:26 GMT

Refer the attachment, if any doubts please post it...

Re: how to insert image in textbox.

amars — Tue, 11 Jun 2013 10:01:49 GMT

Hi Dipak,

just change the textbox like the below

Thanks....

Re: how to insert image in textbox.

Tue, 11 Jun 2013 10:06:52 GMT

Hi amar, Yes, you are absolutely correct.That come after you load the script.

Using the info() also, u can achieve it.Please refer to my attachment Thanks

Re: how to insert image in textbox.

Tue, 11 Jun 2013 11:25:39 GMT

Hi rajni,

I am not getting any image.

its displaying path in txt.

plz find attachment

Re: how to insert image in textbox.

Tue, 11 Jun 2013 11:41:59 GMT

Hi Deepak,

As i am using personal edition so i wont be able to see your attachment.
Please go through my earlier posts and suggest me solution.

Thanks,
Hitesh.

Re: how to insert image in textbox.

Tue, 11 Jun 2013 14:13:08 GMT

Step-1: /*Load this script in your script*/

Images:

Bundle LOAD ImgID,Location

FROM flags\Image_Ex.xlsx (ooxml, embedded labels, table is Sheet1);

Step-2: After step-1, create a text box and go to its properties and in the expression editor type the following:

=Info(ImgID)

Step-3: Change the Representation to Image in drop down.By default, it is Text. Click OK.

Done...Cheers!!!

Re: how to insert image in textbox.

Thu, 13 Jun 2013 05:20:20 GMT

Hi guys,

Still i am not getting proper solution for how to insert image in textbox.

please refer my below attachment and help me out.

thanks.

Re: how to insert image in textbox.

Thu, 13 Jun 2013 06:49:36 GMT

Hiii see the attached file.

Re: how to insert image in textbox.

Thu, 13 Jun 2013 08:13:43 GMT

This is your script:

image:

bundle LOAD ImgID,

Location

FROM [Image Ex.xlsx] (ooxml, embedded labels, table is Sheet1);

********************************************************************

From the above script, I can see that your excel file does not carry any path, plz mention the path, don't just type as Image Ex.xlsx.

Perform the following steps to load the excel file in your script:

Step-1: Suppose you have placed the excel file in your desktop, in theis case I have used your excel sheet in my desktop.

Step-2: Open the script editor by pressing(Ctrl + E), then click on "Table Files" Button.

Step-3: Select the excel file where your have placed it.ie., look in desktop(in my case) and click on Open.

Step-4: Here you can now see you excel sheet contents. Select the 'Embedded labels' under "Labels" and click on finish button.

Step-5: Your script is now ready, give ur table a label and before the load statement use the keyword 'Bundle'.

For your reference, i'm pasting my script below:

image:

Bundle LOAD ImgID, Location

FROM (ooxml, embedded labels, table is Sheet1);

Step-6: After step-5, create a text box and go to its properties and in the expression editor type the following:

=Info(ImgID)

Step-7: Change the Representation to Image in drop down.By default, it is Text. Click OK.

Step-8: When u now click on your ImgID, u will now able to view you image.

Done...Cheers!!!

Re: how to insert image in textbox.

Thu, 03 Sep 2015 02:18:52 GMT

Hi Deepak:

Thank you very much for your post.

When I do bundle load, the table disappeared and I cannot find the ImgID field.

Do you know why?

Thank you.

Re: how to insert image in textbox.

santiago_respane — Wed, 17 Aug 2016 16:27:35 GMT

Hi,

it is very simple, use bundle load as follows.

In script:

bundle load * inline [

imgName,img

img1,C:\Temp\srespane\Education\QV Samples\Infographics\img1.png

img2,C:\Temp\srespane\Education\QV Samples\Infographics\img2.png

];

Then in your text object you will need to add the desired image as follows (don't forget to set Image as value for Representation in text object properties General tab):

='qmem://imgName/img1' //For image 1

='qmem://imgName/img2' //For image 2

Please let me know if this helps.

kind regards,

Re: how to insert image in textbox.

ravikumar89 — Tue, 15 May 2018 16:04:29 GMT

Hi Michael,

Working exactly to my requirement..... thanks alot.