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
Write Table now available in Qlik Cloud Analytics: Read Blog
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
‎2017-01-19 12:58 AM

Issue with Dates - Finding out the max date

I need to display the latest month that may be present in the sheet. Dates are stored in Text format as field name Outage_Month. Values in this field are stored as 11/1/2016,12/1/2016 etc.

I have to display the outage mins for the latest month that may be present at any given point in time.

I used the below dimension in the chart and expression as sum of Mins. This dimension works fine in a text object but when put in a straight chart it should 'Error in calculated dimension'

=if(num(monthstart((max(Outage_Month))))=num(addmonths(monthstart(today()),-1)),monthname(max(Outage_Month)),monthname(AddMonths(today(),-2)))

   

Nov-16
319 Views
0 Likes
1 Reply