Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Conditional replace dimension value with picture


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.

D. Petrov



3 Replies
MVP & Luminary
MVP & Luminary

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

Contributor III
Contributor III

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

Support (Former)
Support (Former)

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


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


To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.