Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
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

Re: Calculating max date for PRODUCT in Load Script

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

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


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