Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

panipat1990
Contributor II

Help

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 ....

1 Solution

Accepted Solutions
MVP
MVP

Re: Help

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;


Capture.PNG

4 Replies
MVP
MVP

Re: Help

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

panipat1990
Contributor II

Re: Help

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

panipat1990
Contributor II

Re: Help

Yes Max Date for the overall date set...

MVP
MVP

Re: Help

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;


Capture.PNG