Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
grajesh_sgp
Contributor III
Contributor III

How to show Image in expression in Qliksence

Hi Experts,

I have requirement where I am put images of up and down arrows in expression using if statement.

As per below data I have write another expression with if statement like

If (maxmonth countID>previousMonth Count, UPARROW image else DOWNARROW image.

Can any one help me how to add images in expression level.

clipboard_image_0.png

Labels (1)
6 Replies
dplr-rn
Partner
Partner

You need extensions for that. Checkout vizlib library (paid) or check Qlik branch for free ones

Out of the box you could color the background based on your if condition instead of doing up and down arrow

joe_warbington
Partner
Partner

That's right. Lots of beautiful customizations to be had with the Vizlib Table and Pivot Table. You can download a trial (free for up to 5 people) of the entire growing Vizlib Library of extensions here: https://home.vizlib.com/vizlib-library-for-qlik-sense/

Additional information and screenshots for the table and the mini-charts: https://community.vizlib.com/support/solutions/articles/35000107232-vizlib-table-overview

Vizlib Table extension for Qlik SenseVizlib Table extension for Qlik Sense

Quy_Nguyen
Specialist
Specialist

Hi,

In case you don't want to use extension, you can try  adding if condition to your expression like this:

- Expression:  

If(Count([ID]) < 1000, '▼','▲')  & ' ' & Count([ID])

- Text color expression: 

 If(Count([ID]) < 1000, Red(),Green())

Result: 

clipboard_image_0.png

 

grajesh_sgp
Contributor III
Contributor III
Author

Thank you for your suggestion ,I will try your solution but how can get that triangle symbols in if condition?

Quy_Nguyen
Specialist
Specialist

simonaubert
Partner
Partner

Hello,

You can use utf8 characters that looks like icons. It's fun, easy and cool.

As an example, a bike 🚲

Or a lightbulb : 💡

A clock : 🕐


The good thing it that you use it in expression and even in script !!

The bad thing : display may vary according to browser, font....

Bi Consultant (Dataviz & Dataprep) @ Business & Decision