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: 
ssha1983
Contributor II
Contributor II

Get Min Date from a chart

Hi

I have a table with a list of dates.

I need the minimum date (31/12/2015) by Document No.  in a chart table.

   

Document No_DateRem AmtMIN(TOTAL <[Document No_]> Date)
-1,633,021.7231/03/2016
GJPAY0000698531/03/201612,162.6531/03/2016
GJPAY0000698529/02/201630,046.7131/03/2016
GJPAY0000698531/01/2016-94,672.0931/03/2016
GJPAY0000698531/12/2015-1,580,558.9931/03/2016

I tried using formula Min(Total <Document No_]> Date). However, I do not get the desired result.

Note there is more there one Document No_ in the chart.

Please help.

3 Replies
Not applicable

Hi,

may be like this

aggr(Min(Total <Document No_]> Date),Document No_)



tamilarasu
Champion
Champion

Try this,

Date(Aggr(Min(Date),[Document No_]))

sunny_talwar

I don't see any issue with the expression. Would you be able to share a sample where it isn't working for you?