Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Text Object

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

2 Replies
swuehl
MVP
MVP

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'

)

Anonymous
Not applicable
Author

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'

)