Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

sjhussain
Contributor II

QlikSense: Images in Tables

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.

1 Solution

Accepted Solutions
brian_holborow
New Contributor III

Re: QlikSense: Images in Tables

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

5 Replies
brian_holborow
New Contributor III

Re: QlikSense: Images in Tables

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
Contributor II

Re: QlikSense: Images in Tables

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.

geminihzh
Valued Contributor

Re: QlikSense: Images in Tables

Hi, Syed,

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

Thanks very much

Zhihong

brian_holborow
New Contributor III

Re: QlikSense: Images in Tables

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

geminihzh
Valued Contributor

Re: QlikSense: Images in Tables

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

Thanks very much

Zhihong