topic Re: Image is not showing with value in QlikView

Image is not showing with value

Thu, 18 Sep 2014 11:11:56 GMT

Hello everyone,

I created this by using pivot table, i wanted to show green arrow when CY>50% i applied a condition but it is showing the text,

Can any body please help me how to show the image with value

Thanks

Re: Image is not showing with value

Gysbert_Wassenaar — Thu, 18 Sep 2014 11:59:21 GMT

The expression can be displayed either as text or as image, not both. If you do need both then you need to use two expressions.

Re: Image is not showing with value

rido1421 — Thu, 18 Sep 2014 12:03:48 GMT

Hi There

Create two columns one with the text and the other with the image

Re: Image is not showing with value

Thu, 18 Sep 2014 12:25:21 GMT

Hello Gysbert,

Thanks for the reply,

I am showing so many values in the single expression only,

Please check my expression below:

=IF(DAY(DATE)>0, if(secondarydimensionality(),

'Revenue:'

&chr(10)&

'CY' & ' '&(Sum(Revenue))&'%'&if((Sum(Revenue))>50,'gmem://<bundled>/BuiltIn/led_g.png','qmem://<bundled>/BuiltIn/led_r.png')&' | '&'LY' & ' '&(Sum(Revenue))&'%'

&chr(10)&

'Sold:'

&chr(10)&

'CY' & ' '&(Sum(Revenue))&'%' &' | '&'LY' & ' '&(Sum(Revenue))&'%'

&chr(10)&

'Growth:'

&chr(10)&

'CY' & ' '&(Sum(Revenue))&'%' &' | '&'LY' & ' '&(Sum(Revenue))&'%' )

,' ')

Thanks