topic Re: Help in QlikView

Help

panipat1990 — Mon, 26 Jan 2026 18:19:17 GMT

Hi Team,

I have an excel With Many Fields....And there is Many Dates in Date Column..But i Want to Maxium Date From Date Column..How is it possible..Please Help me... So For clearing i am attaching excel ....

Re: Help

sunny_talwar — Wed, 04 May 2016 19:11:09 GMT

Max Date for the overall date set? or max per customer? Can you elaborate on the expected output?

Re: Help

panipat1990 — Wed, 04 May 2016 19:16:13 GMT

IN Date Column i want to show only maximum date Just only one date(maximum date).

Re: Help

panipat1990 — Wed, 04 May 2016 19:16:58 GMT

Yes Max Date for the overall date set...

Re: Help

sunny_talwar — Wed, 04 May 2016 19:18:17 GMT

May be try this:

Table:

LOAD CustomerID,

EmployeeID,

Freight,

OrderDate,

OrderID,

ShipperID

FROM

excel_Testing.xls

(biff, embedded labels, table is Sheet1$);

Right Join (Table)

LOAD Max(OrderDate) as OrderDate

Resident Table;