Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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

Highlighted
Luminary
Luminary

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

Highlighted
Creator III
Creator III

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

 

Highlighted
Contributor III
Contributor III

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

Highlighted
Creator III
Creator III

Highlighted
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