QlikSense: Images in Tables

[sjhussain]

Hello,

Is there a way to insert images in Tables in QlikSense just like Qlikview?

We have a table in QlikSense with +ve and -ve values and would like to show respective up and down arrow images in the table.  How is it possible?

Will appreciate assistance.

Thanks.

[brian_holborow · Accepted solution]

Syed

you can use geometric shapes and set their colour: for example the up arrow is chr(9650) and the down arrow is chr(9660) - so add a measure to the table with an expression along the lines of

      if(sum(Metric)>=0,chr(9650),chr(9660))

and then write a similar expression for the text color expression, for example

      if(sum(Metric)>=0,green(),red())

Check Wikipedia or elsewhere on the net for other geometric shapes.

Hope that helps.

Please mark this as helpful / correct if your question has been answered to your satisfaction

Brian

[sjhussain]

Brian,

Thanks a lot.  The geometric shapes are working nicely.

So i guess at this time we do not have the feature of inserting images in QlikSense Table.

Thanks again.

[Anonymous]

Hi, Syed,

May I know is it possible to add color to the geometirc shapes, is that possible?

Thanks very much

Zhihong

[brian_holborow]

Zhihong

You can set the color of the shape by using an expression in the Text Color Expression of the measure you are adding, for example:

      if(sum(Metric)>=0,green(),red())

There are a lot of ways to define the color, such as the Qlik Sense functions used here, but also using rgb(), argb(), hsl(), etc.  More details are available in the Help system.

Hope that helps.

Please mark this as helpful / correct if your question has been answered to your satisfaction

Brian

[Anonymous]

Ah, I see, sorry did not understand the color part in your last reply.

Thanks very much

Zhihong