topic Re: Get Min Date from a chart in QlikView

Get Min Date from a chart

ssha1983 — Wed, 25 Nov 2020 16:16:04 GMT

I have a table with a list of dates.

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

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.

Tue, 31 May 2016 12:09:16 GMT

Hi,

may be like this

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

tamilarasu — Tue, 31 May 2016 12:27:36 GMT

Try this,

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

sunny_talwar — Tue, 31 May 2016 14:48:09 GMT

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