Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
jeevays7
Partner - Creator III
Partner - Creator III

get only sum of the value of first minimum date of the maximum year

How to get sum(value) from this table for each Dept on first minimum date for the year of 2016.

Ex:

Dept     Date     Value     Year

CSE     28-Dec-2015     50     2015

CSE     1-jan-2016     200     2016

CSE     3-jan-2016     100     2016    

EEE     1-jan-2016     150     2016

EEE     3-jan-2016     100     2016

ECE     5-jan-2016     300     2016

ECE     7-jan-2016     400     2016

Result:

CSE     200

EEE     150

ECE     300

10 Replies
sunny_talwar

No problem at all