Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
zied_ahmed1
Specialist
Specialist

Show only the last record in table

Hello ,

I need to show only the last record in the table (the record who have the max finish date : 

In our example I need to display only Construction -> 25/07/2019

 

completed.PNG

Thanks for help 

5 Replies
Anil_Babu_Samineni

If([Finish Date]=Max(TOTAL [Finish Date]), [Finish Date])

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
zied_ahmed1
Specialist
Specialist
Author

Thank you for your answer but it doesn't work 

finish_date.PNG

StarinieriG
Partner - Specialist
Partner - Specialist

Hi,

 

maybe the formula doesn't work beacause of the field, that is not in a date format.

Try with:

If([Finish Date]=Max(TOTAL Date#([Finish Date],'DD/MM/YYYY')), [Finish Date])

zied_ahmed1
Specialist
Specialist
Author

Same problem..

My requirement is to display only the last task completed (On this project for example the last completed task is Construction 25/07/2019)

 

Thanks 

Anil_Babu_Samineni

Try below expressions in text box and see?

Max(TOTAL [Finish Date])

Or

Date(Max(TOTAL [Finish Date]))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)