max date 30th april 2015 require from attached sheet

[yadav_anil782]

Dear All,

i need  max date 30th april from attached excel table , plz share the exprssion how to make it in qlik view

[#2]

It depends how u want. If you want in variable then use

Datetmp:

LOAD A,

Date(A) as DA

FROM

[..\min & max date require.xlsx]

(ooxml, no labels, table is Sheet1);

NoConcatenate

Date:

load * resident Datetmp order by DA asc;

Let maxdate=peek('DA',-1,Date);

Let mindate=peek('DA',0,Date);

drop table Datetmp;

---------------------------------------------------------------------------------------------------

Otherwise use

Date:

LOAD

max(Date(A)) as DAMax,

min(Date(A)) as DAMin

FROM

[..\min & max date require.xlsx]

(ooxml, no labels, table is Sheet1);

[MayilVahanan]

Hi

Are you looking for this?

TestDate:

LOAD

Date(A) as Date

FROM

[min & max date require.xlsx]

(ooxml, no labels, table is Sheet1);

LOAD Date(If(Floor(MonthEnd(MaxDate)) = Floor(MaxDate), MaxDate, MonthEnd(AddMonths(MaxDate, -1)))) As MaxDate;

LOAD Max(Date) as MaxDate Resident TestDate;

MaxDate returns 30th april 2015.