Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
ena1309
Contributor III
Contributor III

Top row in chart

ena1309_0-1653516104106.png

Hi guys, 

how can I make Qlik to show only the latest row i.e. max(run_date) 
please for a solution asap

🙂

Labels (2)
2 Replies
vinieme12
Champion III
Champion III

Dimension

MonthName,AgeGroups

Measure

Sum({<run_date={">=$(=Date(monthstart(max(run_date)),'yyyy-mm-dd'))<=$(=Date(max(run_date),'yyyy-mm-dd'))"}>} YourMeasure)

 

Replace YYYY-MM-DD with the datefoemat in your app

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

Refer below article for more 

https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.