Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sjhussain
Partner - Creator II
Partner - Creator 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
Partner - Contributor III
Partner - Contributor III

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

View solution in original post

5 Replies
brian_holborow
Partner - Contributor III
Partner - Contributor III

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
Partner - Creator II
Partner - Creator II
Author

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
Not applicable

Hi, Syed,

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

Thanks very much

Zhihong

brian_holborow
Partner - Contributor III
Partner - Contributor III

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
Not applicable

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

Thanks very much

Zhihong