Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

Conditional replace dimension value with picture

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

 

 

3 Replies
marcus_sommer
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

d_petrov
Contributor III
Contributor III
Author

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
Support (Former)
Support (Former)

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

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.