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

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: 
Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
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: 
Anonymous
Not applicable
‎2018-03-15 02:01 AM

Formatting date

Any idea to make it to display as in red text? I'm using system default autoCalendar.YearMonth.

Example.png

1,686 Views
0 Likes
13 Replies
tresesco
MVP
MVP
‎2018-03-16 03:33 AM

In response to Chanty4u

I guess OP has got the answer in Prashant's reply and he wanted the format for all dates. However, to clarify your query, if you use calculated dimension, it would only show the effect where you use it.

416 Views
Chanty4u
MVP
MVP
‎2018-03-16 03:34 AM

In response to tresesco

thanks  tresesco‌

416 Views
0 Likes
PrashantSangle
MVP
MVP
‎2018-03-16 08:53 PM

In response to Anonymous

Close the thread by selecting correcting answer.

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
416 Views
0 Likes
simran04
Contributor II
Contributor II
‎2018-03-18 08:46 AM

You can use "If" statement.

E.g., If(Date>'01/10/2018', green(), red()).

The above statement will result in green color if date is greater than the above mentioned date and red if it's below than that.

416 Views
0 Likes