Re: Color Cell In Straight Table If Cell Date Is G... - Qlik Community

Announcements Qlik Connect 2026 Agenda Now Available: Explore Sessions

• Qlik Community
• :
• All Forums
• :
• QlikView App Dev
• :
• Re: Color Cell in Straight Table if cell date is g...

Options

• Subscribe to RSS Feed
• Mark Topic as New
• Mark Topic as Read
• Float this Topic for Current User
• Bookmark
• Subscribe
• Mute
• Printer Friendly Page

All communityThis boardKnowledge baseUsersProducts cancel Turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for  Search instead for  Did you mean:  Not applicable ‎2016-03-03 05:03 PM

• Mark as New
• Bookmark
• Subscribe
• Mute
• Subscribe to RSS Feed
• Permalink
• Print
• Report Inappropriate Content

Color Cell in Straight Table if cell date is greater than 6 months from today's date

I am trying to get the background expression to change to red if the date that is showing in the straight table is greater than 6 months from todays date.

The expression listed below is what I have been work with no success.

({$<PART_RECEIVED_MMonth={"$(=Date(AddMonths(Max(PART_RECEIVED_MMonth),-6),'MMM-YY'))"}>}LightBlue())

Any assistance would be much appreciated

Ditto - same here! 1,222 Views 0 Likes Reply

• All forum topics
• Previous Topic
• Next Topic

1 Solution Accepted Solutions Anonymous Not applicable ‎2016-03-03 06:54 PM Author

• Mark as New
• Bookmark
• Subscribe
• Mute
• Subscribe to RSS Feed
• Permalink
• Print
• Report Inappropriate Content

Not sure I completely understand the requirement, but something like this will tell you whether or not the PART_RECEIVED_MMonth field is greater than 6 months from today:

if( date(PART_RECEIVED_MMonth) > date(addmonths(today(), 6)), red())

View solution in original post

Ditto - same here! 993 Views 0 Likes Reply 3 Replies Anonymous Not applicable ‎2016-03-03 06:54 PM Author

• Mark as New
• Bookmark
• Subscribe
• Mute
• Subscribe to RSS Feed
• Permalink
• Print
• Report Inappropriate Content

Not sure I completely understand the requirement, but something like this will tell you whether or not the PART_RECEIVED_MMonth field is greater than 6 months from today:

if( date(PART_RECEIVED_MMonth) > date(addmonths(today(), 6)), red())

Ditto - same here! 994 Views 0 Likes Reply settu_periasamy Master III ‎2016-03-03 10:27 PM

• Mark as New
• Bookmark
• Subscribe
• Mute
• Subscribe to RSS Feed
• Permalink
• Print
• Report Inappropriate Content

Hi,

You can't directly use the Color (LightBlue) in your set expression.

({$<PART_RECEIVED_MMonth={"$(=Date(AddMonths(Max(PART_RECEIVED_MMonth),-6),'MMM-YY'))"}>}LightBlue())

May be try something like

If (YourDateField > Date(AddMonths(Today(),6)),Red(),LightBlue())

993 Views 0 Likes Reply Anonymous Not applicable ‎2016-03-04 02:29 AM Author

• Mark as New
• Bookmark
• Subscribe
• Mute
• Subscribe to RSS Feed
• Permalink
• Print
• Report Inappropriate Content

Did you check this?

Set the background color of columns in straight table

Colour on column header (straight table) | Qlik Community

Condition Background Colour On Straight Table D... | Qlik Community

993 Views 0 Likes Reply Post Reply Tags

• new_to_qlikview
• new to qlikview
• qlikview_scripting
• qlikview_layout_visuali…
• qlikview_creating_analy…
• qlikview
• script
• chart
• expression
• date
• load
• table
• set_analysis
• expressions
• macro
• analysis
• scripting
• pivot
• set
• dimension

View All ≫ Community Browser

• All Forums
  • GeoAnalytics
  • QlikView Administration
  • QlikView App Dev
  • QlikView Connectivity
  • QlikView Integrations
  • Qlik NPrinting