topic Re: max date 30th april 2015 require from attached sheet in QlikView

max date 30th april 2015 require from attached sheet

yadav_anil782 — Tue, 02 Jun 2015 09:22:28 GMT

Dear All,

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

Tue, 02 Jun 2015 09:37:07 GMT

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 — Tue, 02 Jun 2015 09:50:31 GMT

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.