Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Conditional Formatting

Hi Everyone, I need some help with changing the colour of some of my records if the "Target Date" field is less than today;s date. E.g. Highlight the record in "red" if the "Target Date" is less than today's date and highlight the record in "amber" if the "Target Date" is within the current month. What is the best way to do this, as part of the load script or as an expression in a a table box list. What will be the best functions to use. Thanks

5 Replies
MVP & Luminary
MVP & Luminary

Re: Conditional Formatting

Hi,

You can use the Background color expression to change the back ground color.  Hope the attached files helps you.

Regards,

Jagan.

Not applicable

Conditional Formatting

Thanks very much for the help, that was useful for Charts. How do I change the color of text or row background based on a condition in a Table Box Object

MVP & Luminary
MVP & Luminary

Conditional Formatting

Hi,

There is no such option for Table Box Object, but you can do the same by using the Straight table, you can give back ground color by using the above solution, you can change the text color by using the "Text Color" expression, and you can give the text style by using "Text Format" expression like '<b>' for bold etc.

Regards,

Jagan.

Not applicable

Conditional Formatting

Hi Varkhurst,

I dont think you can change the colours for a Table Box, if you make it a Staight table or Pivot Table, you can use either Jagans solution or use the Visual Cues.

If the reson why you chose to use a Table box was you do not require a Calculated Expression,

Just use a =Count([field]) formula , but hide column in presentation,

You should be able tow tweak it to your needs

Anne

Not applicable

Re: Conditional Formatting

This is really helpful thanks.