topic Text Object in QlikView

Text Object

Thu, 02 Jun 2016 08:11:11 GMT

Good day,

Please help with the below expression, what am trying to achieve here, I want the output to show me a picture of a smile or sad face if the CM amount is less/greater than the PM.

= 'Performance PM vs CM' & NUM(IF((sum({$<Cycle = {$(#vMinCycle)}>} Received) > (sum( {$<Cycle = {$(#vMaxCycle)}>} Received),'qmem://<bundled>/BuiltIn/smiley3_r.png','qmem://<bundled>/BuiltIn/smiley1_g.png')

Many thanks,

Treasure

Re: Text Object

swuehl — Thu, 02 Jun 2016 09:24:40 GMT

I think you need to split your text box into two: One showing the text at the start and one evaluated to the image link (and then you need to change the display option to image):

= IF(

sum({$<Cycle = {$(#vMinCycle)}>} Received) > (sum( {$<Cycle = {$(#vMaxCycle)}>}Received),

'qmem://<bundled>/BuiltIn/smiley3_r.png',

'qmem://<bundled>/BuiltIn/smiley1_g.png'

)

Re: Text Object

Anonymous — Thu, 02 Jun 2016 12:31:53 GMT

You have forbidden a parenthesis:

= IF(

sum({$<Cycle = {$(#vMinCycle)}>} Received) > sum( {$<Cycle = {$(#vMaxCycle)}>}Received),

'qmem://<bundled>/BuiltIn/smiley3_r.png',

'qmem://<bundled>/BuiltIn/smiley1_g.png'

)