Help With Table

[#1]

Hi Guys

I was hoping someone could help. I have a chart as shown in the pic. I was hoping there was a way to add a third emoticon if there is no greater or smaller than figure returned. Please let me know if there is more detail needed.

Regards

[sunny_talwar]

Are you trying to get a new emoticon for when 2012 and 2013 are both 0??

[alexandros17]

Could you share your qvw and explain the question with more details?

[sorrakis01]

Hi ashley,

Are you using Bundle method for the icons?

You can create 3 icons.

And after in expresion use the conditional expresion (If 2014>2013, green, If 2014<2013, red, yellow)

Regards

[Peter_Cammaert]

You mean if LY and CY have equal values (or both are zero)? Normally you check for something like A<B->Icon1 else Icon2. Change this into something like:

=IF (ColumnY2 < ColumnY1, 'PathToIconLT', IF (Column2 > Column1, 'PathToIconGT', 'PathToIconEQ')).

Peter

[#6]

Yes i would like it if the value is 0 then a yellow emoticon. My expression is the following.

=if(sum({<Year={'2012'}>} [Mass Out]*IsProduction) >= sum({<Year={'2013'}>} [Mass Out]*IsProduction),

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

Regards

[Peter_Cammaert · Accepted solution]

=if(sum({<Year={'2012'}>} [Mass Out]*IsProduction) > sum({<Year={'2013'}>} [Mass Out]*IsProduction),

'qmem://<bundled>/BuiltIn/smiley3_r.png', if (sum({<Year={'2012'}>} [Mass Out]*IsProduction) < sum({<Year={'2013'}>} [Mass Out]*IsProduction),'qmem://<bundled>/BuiltIn/smiley1_g.png', 'qmem://<bundled>/BuiltIn/smiley1_y.png'))

[sunny_talwar]

Try this:

=If(Sum({<Year={'2012'}>} [Mass Out]*IsProduction) > Sum({<Year={'2013'}>} [Mass Out]*IsProduction),

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

If(Sum({<Year={'2012'}>} [Mass Out]*IsProduction) < Sum({<Year={'2013'}>} [MassOut]*IsProduction), 'qmem://<bundled>/BuiltIn/smiley1_g.png', 'anotherImage'))

[Peter_Cammaert]

Two nested IFs handle three cases: <, =, >

Peter

[#10]

That is perfect and works 100%. Thank you so so much for the help all.