topic Re: image in expression? in QlikView

image in expression?

Fri, 21 Mar 2014 14:00:30 GMT

Hi Experts,

I am getting not getting the expected output from the below expression:

=if((vCurrentYearSales-vPreviousYearSales)>0, Num((vCurrentYearSales-vPreviousYearSales)/100,'###.00% qmem://<bundled>/BuiltIn/thumb2.png'), Num((vCurrentYearSales-vPreviousYearSales)/100, '- ###.00% qmem://<bundled>/BuiltIn/thumb1.png'))

I have selected the representation as Image in the General tab of the text box.

I get the output as below.

How do I resolve this issue?

Thanks.

Re: image in expression?

Gysbert_Wassenaar — Fri, 21 Mar 2014 14:33:02 GMT

Use two text boxes. One text box can have only one representation, either text or image, never both at the same time. So put the text box with the image on top of the one with the text. Just make the one with the text large enough so the text will be visible above the image.

Re: image in expression?

spividori — Fri, 21 Mar 2014 14:33:19 GMT

HI.

You should make an expression for the % and another expression for the image

I do not know if you can do what you want.

Regards.

Re: image in expression?

marcus_sommer — Fri, 21 Mar 2014 14:34:27 GMT

Your link to the picture couldn't be inside a formatting-function - try it with a concat like this:

if(condition, expression-result1 & picture1, expression-result2 & picture2)

- Marcus

Re: image in expression?

Tue, 25 Mar 2014 19:09:55 GMT

Thank you guys. Got it resolved..