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
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
niha
Creator II
Creator II

How to Insert Image in a If else logic

Hello,

I want to add a If else statement like this:

If ( (PMPM Amount Year ago)> (PMPM Amount), Image Arrowupward, else Imagearrowdownward). Please find the screen shot. 

I am interested for Variance Field arrow. Please suggest.

Regards,

Niha

Untitled.png

10 Replies
segador_
Partner
Partner

Hi!

You cannot insert images in Pivot tables or Tables. 

But if you need to show arrow symbols, you can use expressions with Unicode characters like this:

if(rand() > 0.5,'↑','↓')

Just copy expression to your measure and replace rand() function with your expression.

More Unicode symbols you may find at https://unicode-table.com/en/

Or you may use extensions with image-representation functionality, like this https://developer.qlik.com/garden/567836fd8703093925d91d03.

 

Regards, Igor.
ajaykakkar93
Specialist
Specialist

This is the only solution when it come to default table/pivot table in qlik sense
niha
Creator II
Creator II
Author

Thanks . That works but is there any way I can make the arrow width bigger: Untitled.png

segador_
Partner
Partner

You can choose another arrow symbols. For example:

⬆⬇  🡅🡇  🡁🡃 🠝🠟 ⮉⮋ 🢁🢃

It will look like this

1.png

 

Regards, Igor.
ajaykakkar93
Specialist
Specialist

Hi,
Main issue is the font size of the char value, which we don't have in our default chart property. But if you are flexible with option then you can create/ use table extension (it has its own set of issue).
niha
Creator II
Creator II
Author

Thank you so much for the input.  Can you please elaborate how did you get this arrow symbol? The url provided also vast .

any of the line is fine. But I want to know the process. 

regards,

Niha 

niha
Creator II
Creator II
Author

Hello,

thanks. Yes I do see that in Qliksense we have to use extension a lot. for example. Font size, Style etc. I am new to extension and we use Cloud . If you could elaborate this extension and how to apply it, would be great.

Regards,

Niah

ajaykakkar93
Specialist
Specialist

in cloud u cannot upload extensions, you will get certified set of extension bundles only.
niha
Creator II
Creator II
Author

Hello,

Two extension or custom objects are available for me and I believe the name of extension has to be attached in server Not sure. Happy to know more about it as I need it.