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
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
‎2012-08-03 03:19 PM

formatting dates

Hi, I have an If statement in my Dimension Expresion box to limit my date dimension to 18 months.

=Date(If(PeriodDate > MonthStart(Today(),-18), PeriodDate, Null()), 'MMM/YYY')

It works in limiting my chart to 18 months but now the dates show as numbers ( 40600 etc ).  How can I get these to show as dates.  The load statements loads the dates as MM/YYYY.    Thanks, Jim

1,188 Views
0 Likes
10 Replies
Not applicable
‎2012-08-06 09:02 AM
Author

In response to Anonymous

Thanks everyone for all of your help!!!

116 Views
0 Likes