Qlik Community

App Development

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

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
sjhussain
Partner
Partner

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
Partner

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
Partner

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

sjhussain
Partner
Partner
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.

geminihzh
Specialist
Specialist

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
Partner

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
Specialist
Specialist

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

Thanks very much

Zhihong