Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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.