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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2015-03-19 04:28 AM

Getting the info from the max date

Hi guys!

Need your help!!!

I have 2  documents having the same field name like "Employee".

Here is the first table in Excel:

There are  fields with "Account" and Months, and I need to find the latest Account where the values end and start null values. I need to find the latest start date of the Account of some person and join the name of Account to the other table next to the name of Employee.

Can You help me please?

Labels (1)
Labels
362 Views
0 Likes
0 Replies