topic Re: QlikSense: Images in Tables in App Development

QlikSense: Images in Tables

sjhussain — Sat, 19 Sep 2015 13:53:18 GMT

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.

Re: QlikSense: Images in Tables

brian_holborow — Sun, 20 Sep 2015 01:22:00 GMT

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

Re: QlikSense: Images in Tables

sjhussain — Mon, 21 Sep 2015 07:54:35 GMT

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.

Re: QlikSense: Images in Tables

Anonymous — Tue, 26 Jul 2016 15:37:47 GMT

Hi, Syed,

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

Thanks very much

Zhihong

Re: QlikSense: Images in Tables

brian_holborow — Wed, 27 Jul 2016 04:25:46 GMT

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

Re: QlikSense: Images in Tables

Anonymous — Wed, 27 Jul 2016 07:57:21 GMT

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

Thanks very much

Zhihong