topic Concatenate Images in Chart in QlikView

Concatenate Images in Chart

Anonymous — Wed, 06 May 2015 14:28:53 GMT

Hi,

I'm trying to concatenate images in a chart and was wandering if anyone has come across a solution.

I've got the expression in straight table, as below:

CONCAT

(
IF( DRAMScore = 1, 'qmem://<bundled>/BuiltIn/led_g.png',
IF( DRAMScore = 2, 'qmem://<bundled>/BuiltIn/led_o.png',
IF( DRAMScore = 3, 'qmem://<bundled>/BuiltIn/led_r.png', 'qmem://<bundled>/BuiltIn/led_g.png')))
, ' ')

Representation is Image.

If it returns one result it shows the image, but if more than, it returns the string.

Any thoughts or ideas greatly appreciated.

Thanks

Re: Concatenate Images in Chart

Anonymous — Wed, 06 May 2015 15:11:13 GMT

I doubt you can concatenate images. Try a traffic light gauge instead.

Re: Concatenate Images in Chart

rubenmarin — Wed, 06 May 2015 15:19:32 GMT

I think you can't concatenate images, but if you want to try, try it first directly using the string, ie your expression can return:

'qmem://<bundled>/BuiltIn/led_r.png qmem://<bundled>/BuiltIn/led_g.png' <-- this doesn't works

If you find some way to concatenate images I can help with the formula to build that string.

As a workaround you can do 3 expressions, one for each image.