topic Re: Background image in QlikView

Background image

Wed, 14 Nov 2012 09:11:11 GMT

Hello!

How can I set remote background image for sheet?

Re: Background image

Gysbert_Wassenaar — Wed, 14 Nov 2012 09:27:43 GMT

Right click on the sheet, choose properties. Choose Sheet Settings and check the Image option. Then click the change button to select an image.

Re: Background image

Wed, 14 Nov 2012 09:36:09 GMT

It works if I select image on my computer.

But what I should do if I want put in a url, like http://a0.twimg.com/profile_background_images/652311473/zhe4m61tuh1ts0ofyreq.jpeg ?

Re: Background image

Gysbert_Wassenaar — Wed, 14 Nov 2012 09:47:57 GMT

That's not possible afaik. You'll have to download the image first. Qlikview stores the image internally when you set it as background image. It doesn't dynamically load the image when you open the qvw document. So you might as well download the image first and save it locally.

Re: Background image

Jason_Michaelides — Wed, 14 Nov 2012 09:49:25 GMT

I don't think you can make the sheet background link to an online image. A workaround would be to create a text box the size of the sheet, put the URL in the Text window and select Image from the Representation drop-down.

Hope this helps,

Jason

Re: Background image

Wed, 14 Nov 2012 09:58:20 GMT

Can you help me, what I need to do to download this file? Can I do it in script?

Re: Background image

Wed, 14 Nov 2012 10:02:30 GMT

Thank you, Jason. I did it, but I can't solve two problem - how can I stretch textbox dynamically and can't set tiled mode for textbox image

Re: Background image

Wed, 14 Nov 2012 10:20:16 GMT

😃 I meant where can I do it in code

Re: Background image

Jason_Michaelides — Wed, 14 Nov 2012 10:21:41 GMT

Only way of dynamically stretching the text box is to use a macro. And I don't think there is a "tiled" mode. Are these really necessary?

Re: Background image

Gysbert_Wassenaar — Wed, 14 Nov 2012 10:36:34 GMT

See attached example. The macro needs system access. And I have no idea if this will work if the document is published on qlikview server.

Re: Background image

Thu, 15 Nov 2012 03:25:42 GMT

Yes, it looks not good. But if I need use macro anyway then I download image first...

Thank you wery much!

Re: Background image

Thu, 15 Nov 2012 03:32:26 GMT

Thanks a lot! It works as I need to.

One more question: what works first, script or macro? I ask because my url adress can change dynamically, I sometimes I need to update the image. The url takes from the script data.