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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to get a minimum date for an ID in the script?

Hello All,

I'm new to Qlik and have been trying to learn Qliksense, It's a very good progress since a couple of weeks. All your posts and responses have been a great help in my learning process. Now, i've a requirement where I want to extract the Minimum date for an ID. In Cognos, it would be like Min([Hist_Date] for ID) and the Output for this would be as mentioned below.

ID      Hist_Date

1       12/31/2018

1       12/12/2018

1       01/12/2018

The result for Min([Hist_Date] for ID) is 01/12/2018. Please help me achieve this in Qliksense.




Thanks,

Raj

1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

LOAD

Min(Hist_Date) as mindate

FROM ...

Group By ID;

-Rob