Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Conditional Text Formatting on Pivot Table

I'm trying to do a conditional formatting on a Pivot Table where one of the dimensions is the Months.  I'd like to have the past months to be in bold font.  Somehow, it's partly doing it with this:

if(Month(EffectiveDate) < Month(Today()), '<b>'))

It works partly because in some selections, some (yes, just some) of the past months is not showing as bold.  Not sure what I'm missing.

Please help!  I'm a newbie!

17 Replies
Not applicable
Author

no difference.  still the same.

maxgro
MVP
MVP

and if you add 2 expressions

max(Month(EffectiveDate))

Month(Today())

what do you get for Mar, Apr?

Not applicable
Author

10 and 11 for March and April, respectively.

Not applicable
Author

Attached is an example of what I'm trying to do.  the 'C' should be bold based on the conditional formatting I gave but since Q1 is zero for C, the Dimension is not showing bold.

gmoraleswit
Partner - Creator II
Partner - Creator II

You can have zeros instead of nulls, it seams like  this solves the problem (see attached)

Not applicable
Author

It works. Thank you.  However, some of my Pivot Tables turn to all zeros after I un-select the 'Suppress Zero-Values'.  I'll research on that next.  Let me know if you know the answer to that as well.

Thank you.

Not applicable
Author

Is there another way of accomplishing this.  I have fields that are all zeros and I want to hide them.

gmoraleswit
Partner - Creator II
Partner - Creator II

I couldn't find a nice way to do it, but what you can do is add another expression that populates the cells with 'ones' only for the first value/row (in case its always the same or you can calculate it someway)

See attachment