This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
I would like to retrieve one and only one value for each of the following records, regardless of duplicates.
The criteria is the ID and the minimum date
load * inline [
ID, moddate, activityname, attempt
1, 1/1/2021, ms1, attempt 1
1, 1/1/2021, ms1, attempt 2
1, 1/5/2021, ms2, attempt 3
2, 3/1/2021, ms1, attempt 1
so the results would be
1, 1/1/2021, ms1
2, 3/1/2021, ms2
Hi @RogerG, I suggest you to use a group by clause:
Min(Date(moddate)) as moddate
Group by moddate;
drop table RawData;
Thanks, this project was cancelled on me, sorry for the late response