Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
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