topic Conditional Formatting in QlikView

Conditional Formatting

Tue, 13 Mar 2012 15:32:40 GMT

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

Re: Conditional Formatting

jagan — Wed, 14 Mar 2012 09:09:15 GMT

Hi,

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

Regards,

Jagan.

Conditional Formatting

Wed, 14 Mar 2012 15:52:44 GMT

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

Conditional Formatting

jagan — Thu, 15 Mar 2012 05:52:41 GMT

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.

Conditional Formatting

Tue, 20 Mar 2012 14:16:44 GMT

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

Re: Conditional Formatting

Wed, 20 May 2015 13:27:33 GMT

This is really helpful thanks.