Issue with Dates - Finding out the max date

Anonymous — Thu, 19 Jan 2017 05:58:09 GMT

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

Re: Issue with Dates - Finding out the max date

MK_QSL — Thu, 19 Jan 2017 08:43:55 GMT

Provide sample data or sample app to work..

QlikCommunity Tip: How to get answers to your post?

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

topic Issue with Dates - Finding out the max date in QlikView

Issue with Dates - Finding out the max date

Re: Issue with Dates - Finding out the max date