Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
how can I make Qlik to show only the latest row i.e. max(run_date)
please for a solution asap
🙂
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
Refer below article for more
https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511