Search by Keyword

Sense Excel the Add-In for Microsoft

If you miss something please send us an email. Thanks!

SenseImage / Qlik.SenseImage

You are here:
<< Back to all topics

Usage: Insert formula into cell

=Qlik.SenseImage(“Url”)

For example for https://upload.wikimedia.org/wikipedia/commons/thumb/b/b7/Europe_topography_map.png/220px-Europe_topography_map.png

Results in

The resulting image is bound to the cell with and height if you change height / widt of the cell, the picturw scales too:

Basically the picture I only an overlay over the cell. Its not into the cell, so you can move it around, but this would make no sense…

What you see now. Is a ID value, which the SenseImage calculates for the cell, which AG is using to find the cell and insert the picture over it.

You can also load images from the contetnt libraray with:

=Qlik.SenseImage(“ctlib:<contentlibrary>:<filename>”)

You can also use it in Tables:

With the following tabledefinition:

Excel Formula is: =Qlik.SenseImage(“ctlib:analyticsgate:IMG_”&H3&”.jpg”)
So a part of the imagename is the value in the first column

Of course, filenames with spaces don’t work, so you have to play around with qlik (replace them with _ and upload an image with this name  for example)

Also Empty cells or cells with a ‘-‘ you have to build an excel formula, which returns an default or empty image….

If you want to reload all SenseImage Pictures, simply click:

Fore e.g.: to test the attached document just copy the images to the content library analyticsgate and connect…

Note:

If an image could not be loaded or an error occurs while loading, there is now an defaultimage saying “image unavailable”

You can change this image with a new  setting ‘Default path for  SenseImage formula’

Here, again, you can enter anything you could pass as parameter to Senseimage formula:

  • Url
  • file in a network share  or in your file system (\\Intranet\… Or C:\images\…)
  • file in any content libraray (ctlib:…)
Was this article helpful?
0 out Of 5 Stars
5 Sterne 0%
4 Sterne 0%
3 Sterne 0%
2 Sterne 0%
1 Sterne 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Need help?
No Comments

Post a Comment

Comment
Name
Email
Website