How to Insert Image in a If else logic

[niha]

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

[segador_]

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.

[ajaykakkar93]

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

[niha]

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

[segador_]

You can choose another arrow symbols. For example:

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

It will look like this

[ajaykakkar93]

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]

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]

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]

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

[niha]

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.