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
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
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: 
sagarrahul
Creator
Creator
‎2016-07-18 01:42 AM

max clm_no

this is my table

       

ValuestatusMax_dateclm_noCurrent_dateDiffernceclm_num
-Not Outlier04-Jan-2016RC-HS15-10325506-118/07/2016197-
1.000Outlier30-Nov-2015RC-HS15-1032550618/07/2016232-
1.000Outlier24-Dec-2015RC-HS15-1032964718/07/2016208-
1.000Outlier06-Dec-2015RC-HS15-1032650718/07/2016226-
-Not Outlier26-Jan-2016RC-HS15-10325506-218/07/2016175-
0.000Not Outlier01-May-2016RC-HS16-1034954418/07/201679-
-Not Outlier31-May-2016RC-HS16-10349544-118/07/201649-
1.250Outlier31-May-2016RC-HS16-10349544-118/07/201649-

in this i want highest max date along with its clm_no but i dont want its supplementary clm no

above table giving me right but it showing me with supplementary clm_no that i dont wnt so it should give

       

ValuestatusMax_dateclm_noCurrent_dateDiffernceclm_num
-Not Outlier04-Jan-2016RC-HS15-10325506-118/07/2016197-
1.000Outlier30-Nov-2015RC-HS15-1032550618/07/2016232-
1.000Outlier24-Dec-2015RC-HS15-1032964718/07/2016208-
1.000Outlier06-Dec-2015RC-HS15-1032650718/07/2016226-
-Not Outlier26-Jan-2016RC-HS15-10325506-218/07/2016175-
0.000Not Outlier01-May-2016RC-HS16-1034954418/07/201679-
-Not Outlier31-May-2016RC-HS16-10349544-118/07/201649-
1.250Outlier01-May-2016RC-HS16-1034954418/07/201649-

so can any on help me in this

207 Views
0 Likes
0 Replies