Conditional replace dimension value with picture

[d_petrov]

Hello,

I have pivot table where one of  the dimensions is moved at the top. It represents day by day timeline. 

I need if the day is matching today to be replaced with down pointing arrow, instead of the T.

My current dimension is calculated (1 on the screenshot):

=If(DATE(Today(),'DD-MMM-YYYY ') = DATE(Single_Day,'DD-MMM-YYYY '), 'T', DATE(Single_Day,'DD-MMM-YYYY '))
I tried with picking an image , but it is not visible (2 on the screenshot):

=If(DATE(Today(),'DD-MMM-YYYY ') = DATE(Single_Day,'DD-MMM-YYYY '), 'qmem:///BuiltIn/arrow_s_g.png', DATE(Single_Day,'DD-MMM-YYYY '))

Why I can`t see the image? Please, help.

Regards,
D. Petrov

[marcus_sommer]

I'm not sure if it's possible at least not with mixed results of normal string-values and pictures. But you could replace your arrow-picture with an unicode char, see: https://www.key-shortcut.com/schriftsysteme/35-symbole/pfeile.

- Marcus

[d_petrov]

Thanks Marcus,

I have already done this playing with the Chr(8659), Chr(8595) and Chr(9660) , but with integrated image would look more beautiful. If it is not really possible I will stay with Chrs.

Thanks and Regards,

D. Petrov

[Brett_Bleess]

May have a possibility for you, check the following Article link:

https://support.qlik.com/articles/000002596

You may need an '=' in front of things in the expression, hopefully that may do the trick here!

Cheers,
Brett