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

Anonymous — Fri, 21 Sep 2018 14:30:03 GMT

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

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

rwunderlich — Fri, 21 Sep 2018 15:52:58 GMT

LOAD

Min(Hist_Date) as mindate

FROM ...

Group By ID;

-Rob

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

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

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