Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
LOAD
Min(Hist_Date) as mindate
FROM ...
Group By ID;
-Rob