Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Luis171190
Contributor
Contributor

Last record by date

Good afternoon, I wanted to know how to obtain the last two records for each day, for the loading of scripts. This is the table I have.

 

materials date
12324199 1/1/2022
12349090 2/1/2022
12390984 3/1/2022
12390985 4/1/2022
12390986 5/1/2022
12391758 6/1/2022
12403498 7/1/2022
12415203 8/1/2022
12419181 1/2/2022
12427423 2/2/2022
12457274 3/2/2022
12494595 4/2/2022
12789952 5/2/2022
11534159 6/2/2022
12076156 7/2/2022
12115855 8/2/2022
12415202 1/3/2022
12151876 2/3/2022
12153645 3/3/2022
12171508 4/3/2022
12427421 5/3/2022
10516043 6/3/2022
11110353 7/3/2022
12947522 8/3/2022

 

Thank you so much!

10 Replies
sidhiq91
Specialist II
Specialist II

@Luis171190  You are not getting Mar data because my data does not contain Mar data, I have included only Jan and Feb.  You can follow the remaining steps.