Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
MalcolmCICWF
Contributor II

Conditional Formatting for a Single Cell in a Chart

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.

QV Capture.JPG.jpg

1 Solution

Accepted Solutions

Re: Conditional Formatting for a Single Cell in a Chart

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

5 Replies

Re: Conditional Formatting for a Single Cell in a Chart

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
Contributor II

Re: Conditional Formatting for a Single Cell in a Chart

that work very well, thank you Nicole!

MalcolmCICWF
Contributor II

Re: Conditional Formatting for a Single Cell in a Chart

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

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
Contributor II

Re: Conditional Formatting for a Single Cell in a Chart

Dang, I was so close! Thanks again.