Conditional Formatting for a Single Cell in a Chart

[MalcolmCICWF]

I have the below setup in my Qlikview report and I was wondering if there was a way to make a conditional formatting work so that only my Liquidation type displays a number with decimals. I want to keep all my other numbers rounded to a whole number.

[Nicole-Smith · Accepted solution]

Something like this for the expression:

if(Field = 'Liquidation', num(/*Your Expression*/, '#,##0.00'), num(/*Your Expression*/,'#,##0'))

Then leave the formatting for the expression on the Number tab set to "Expression Default".

[MalcolmCICWF]

that work very well, thank you Nicole!

[MalcolmCICWF]

So similar question on the formatting for specific cells in a chart...

How would you add anotehr formatting condition for a percentage in that expression? Lets say if Field='GROSS' then it is a percent. I cant seem to place it in correctly.

[Nicole-Smith]

If I understand what you're after...

if(Field = 'Liquidation', num(/*Your Expression*/, '#,##0.00'),

if(Field = 'GROSS', num(/*Your Expression*/, '##.##%'), num(/*Your Expression*/,'#,##0')))

[MalcolmCICWF]

Dang, I was so close! Thanks again.