Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor II

Calculating max date for PRODUCT in Load Script

I have list of Products and some execution dates are getting generated against them link below

PROD   Date

A             12/06/19

B             12/06/19

A             15/06/19

A             16/06/19 

B             14/06/19

C            12/06/19

 

I want to calculate max date against each PROD execution at Script level so that it will show PROD and Max Data against it in Date column

How can I calculate this in Load Script?

Labels (1)
1 Reply
Highlighted
MVP
MVP

Re: Calculating max date for PRODUCT in Load Script

After loading the products and dates (into table 'Data' for example):

Left Join(Data)
LOAD PROD, 
	Max(Date) as ProductMaxDate
Resident Data
Group By PROD;

 

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein