Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
1 Reply