Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aniket_2701
Contributor
Contributor

Date and Time maximum data

Hi all,

Data:   

Prod, Sales,Date

    A, 10, 10 Jan 15 4pm

    A, 10, 10 Jan 15 9pm

    B, 10, 10 Jan 15 8pm

    B, 10, 10 Jan 15 11pm

    C, 10, 10 Jan 15 9pm

    A, 10, 15 Jan 15 1pm

    A, 10, 15 Jan 15 3pm

    A, 10, 15 Jan 15 6pm

    B, 10, 15 Jan 15 9pm

    C, 10, 15 Jan 15 3pm

    C, 10, 15 Jan 15 9pm

    C, 10, 15 Jan 15 7pm

    A, 10, 21 Feb 15 7pm

    B, 10, 21 Feb 15 4pm

    B, 10, 21 Feb 15 6pm

    C, 10, 21 Feb 15 11am

    C, 10, 21 Feb 15 4pm

    C, 10, 21 Feb 15 9pm

    ,

];

Please show the output ,

specific product and specific date wise ,max order date

Output :

A : 10 JAN 15 9pm

A : 15 JAN 15 3pm

A : 21 Feb  15 2pm

B : 10 Jan  15 11pm

B : 15 Jan  15 9pm

B : 21 Feb 15 6pm

C :10 Jan 15 9pm

C : 15 Jan 15 9pm

C : 21 Feb 15 9pm

Thanks

13 Replies
aniket_2701
Contributor
Contributor
Author

Ex:

1 jan 9pm

1 jan 5pm

max sales time is : 1 jan 9pm

That i expect

MK_QSL
MVP
MVP

Where is 1st Jan in your sample data...??????

Peter_Cammaert
Partner
Partner

Can you tell us where exactly Manish' solution goes wrong? As far as I can see, it works perfectly. Given the source data, the latest time per Prod per day is listed in each and every case.

Date and Time Maximum Data thread265243.jpg

MK_QSL
MVP
MVP

aniket_2701what's wrong with my answer?

I had given the same one !!