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: 
Michael_t
Contributor II
Contributor II

Aide conception script

Bonjour,

Je suis tout nouveau dans le monde de Qlik sense . J’aimerais savoir comment fait-on pour sélectionner les données en fonction d’une date (la plus récente) dans le script.

exemple fichier de données:

id|donnee1|donnee2|       date       |
1 |       A         |        B        |01/01/2020|
2 |       Z         |        E        |01/01/2020|
1 |       C         |         R       |02/01/2021|

Table chargée attendue : clé id sélection date la plus récente.

id|donnee1|donnee2|       date       |
2 |       Z         |        E        |01/01/2020|
1 |       C         |         R       |02/01/2021|


merci d’avance pour vos réponses.

michael.

 

1 Solution

Accepted Solutions
Anil_Babu_Samineni
MVP
MVP

You can play around like

Load id, Max(date) as date Resident Table Group By id;

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

2 Replies
Anil_Babu_Samineni
MVP
MVP

You can play around like

Load id, Max(date) as date Resident Table Group By id;

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Michael_t
Contributor II
Contributor II
Author

Merci effectivement.