Qlik

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: 

New to Qlik Analytics

If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG

Who Me Too'd this topic

lakshmittpd
Contributor
Contributor
‎2023-06-08 09:56 AM

Find the latest date

Hi All,

I have the below data:

 

Product Date 1 Date 2 Date 3 Date 4 Next Date
A 22/05/2011   5/7/2023 11/5/2032  
B   11/5/2032 4/12/2019 7/7/2012  
C 5/7/2023 22/05/2011 2/4/2023 22/05/2011  
D 5/8/2021 4/12/2019   5/7/2023  
E   7/7/2012   4/12/2019  
F 2/4/2023 22/11/2016 7/7/2012 11/5/2032  

 

The next date column should show next nearest date's column name i.e for A it should be 5/7/2023, B 11/5/2032  and so on

Please help with this.

 

Thanks in advance.

Labels (4)
Labels
1 user say ditto
257 Views
0 Likes
Who Me Too'd this topic