Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
rajesh_musturu
New Contributor

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
MVP & Luminary
MVP & Luminary

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

LOAD

Min(Hist_Date) as mindate

FROM ...

Group By ID;

-Rob