topic Re: Conditional replace dimension value with picture in QlikView

Conditional replace dimension value with picture

d_petrov — Mon, 15 Jul 2019 12:31:15 GMT

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

Re: Conditional replace dimension value with picture

marcus_sommer — Mon, 15 Jul 2019 13:37:09 GMT

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

Re: Conditional replace dimension value with picture

d_petrov — Mon, 15 Jul 2019 13:54:58 GMT

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

Re: Conditional replace dimension value with picture

Brett_Bleess — Wed, 07 Aug 2019 20:10:03 GMT

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