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 first row in a simple table

Hello,

I have the list of tasks completed and i need to show only the last one (so the last row ) 

for example in this table I need only to show Construction and the date (first record)

completed.PNG

Thanks 

1 Solution

Accepted Solutions
zied_ahmed1
Specialist
Specialist
Author

this is the solution : 

left join
load Distinct
//Risque_id,
Date(min("date_birthday"),'DD/MM/YYYY') as "TXT Date",
1 as flag

resident Table1;

View solution in original post

2 Replies
Stoyan_Terziev
Partner - Creator III
Partner - Creator III

Hello Zied,

 

I presume that's a table with dimension 'Task Name' and measure Max(Finish Date).

Go to the dimension and select Limitation -> Fixed Number -> Top -> 1

Make sure to uncheck 'Others'.

 

I hope that helps!

 

Kind regards,

S.T.

zied_ahmed1
Specialist
Specialist
Author

this is the solution : 

left join
load Distinct
//Risque_id,
Date(min("date_birthday"),'DD/MM/YYYY') as "TXT Date",
1 as flag

resident Table1;