topic Conditional Formatting for a Single Cell in a Chart in QlikView

Conditional Formatting for a Single Cell in a Chart

MalcolmCICWF — Mon, 24 Mar 2014 17:19:50 GMT

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.

Re: Conditional Formatting for a Single Cell in a Chart

Nicole-Smith — Mon, 24 Mar 2014 17:32:16 GMT

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".

Re: Conditional Formatting for a Single Cell in a Chart

MalcolmCICWF — Mon, 24 Mar 2014 19:04:22 GMT

that work very well, thank you Nicole!

Re: Conditional Formatting for a Single Cell in a Chart

MalcolmCICWF — Tue, 25 Mar 2014 19:03:16 GMT

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.

Re: Conditional Formatting for a Single Cell in a Chart

Nicole-Smith — Tue, 25 Mar 2014 19:06:47 GMT

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')))

Re: Conditional Formatting for a Single Cell in a Chart

MalcolmCICWF — Tue, 25 Mar 2014 19:15:46 GMT

Dang, I was so close! Thanks again.