Skip to main content

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: 
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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: 
Sxbbb
Creator III
Creator III
‎2023-12-18 09:13 PM

I want to show MAE_Type  at  Max(MAE_CreateDate)

I Have Data 

 

Sxbbb_0-1702951915811.png

I want to show MAE_Type  at  Max(MAE_CreateDate) 

I tried but it's not correct :

Sxbbb_1-1702951929433.png

 

 

310 Views
0 Likes
3 Replies
Anil_Babu_Samineni
MVP
MVP
‎2023-12-19 12:51 AM

Not sure the idea why you want to show Max. Anyway, since this filed contains string, Maybe

MaxString(MAE_CreateDate)

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
290 Views
0 Likes
Sxbbb
Creator III
Creator III
‎2023-12-19 09:33 PM
Author

I want to display the latest MAE_Type.  can see it from MAE_CreateDate. 

EX FT_ID = 20110324  The latest MAE_Type is Dismantle.  

Sxbbb_0-1703038389965.png

I tried 

Sxbbb_1-1703038467106.png

The displayed value is correct.

Sxbbb_2-1703039502563.png

However, if FT_ID is not selected, the value will not be displayed.

Sxbbb_3-1703039576443.png

 

 

278 Views
0 Likes
Sivapriya_d
Creator
Creator
‎2023-12-20 06:04 AM

Can you please provide more details like  expected output table i.e expected columns and are you expecting to display only the latest date for FT_ID with latest MAE_Type.

264 Views
0 Likes