Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
MVP
MVP

Re: Text Object

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'

)

manucamon
Valued Contributor III

Re: Text Object

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'

)

Community Browser