Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
panipat1990
Creator II
Creator 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
sunny_talwar

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

View solution in original post

4 Replies
sunny_talwar

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

panipat1990
Creator II
Creator II
Author

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

panipat1990
Creator II
Creator II
Author

Yes Max Date for the overall date set...

sunny_talwar

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