Sense Excel, the Add-In for Microsoft

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

<< Back to all topics
You are here:
Print

=Qlik.SenseImage

Usage: Insert formula into cell =Qlik.SenseImage(“Url”)

Results in

The resulting image is bound to the cell with height and width; if you change height / width of the cell, the picture scales too.

The image is not anchored in the cell, but is an overlay. You can move the image as you like.

What you see now is an ID value, which the SenseImage calculates for the cell, and which AnalyticsGate uses to find the cell and insert the picture over it.

You can also load images from the content library with: =Qlik.SenseImage(“ctlib:<contentlibrary>:<filename>”)

You can also use it in tables …

… with the following table definition.

The Excel Formula is: =Qlik.SenseImage(“ctlib:analyticsgate:IMG_”&H3&”.jpg”). So a part of the image name is the value in the first column. Of course, filenames with spaces don’t work, so you have to play around with qlik (replace every space by a #_# and upload an image with this name for example). Also empty cells or cells with a ‘-‘ do not work; you have to build an excel formula, which returns a default or empty image.

If you want to reload all SenseImage Pictures simply click.

Example: 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 a default image 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 a parameter to SenseImage formula.

– Url
– file in a network share or in your file system (\\Intranet\… Or C:\images\…)
– file in any content library (ctlib:…)

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
Please Share Your Feedback
How Can We Improve This Article?
Need help?
No Comments

Post a Comment

Comment
Name
Email
Website