Qlik Community

App Development

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

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
nrwlafhus
Contributor II
Contributor II

Select Most Recent Record

I am trying to select to most recent record where Planned = 'N' (for the given combination of dimensions).

Here is my table:

nrwlafhus_0-1632497751022.png

I want the output to only show the following highlighted row:

nrwlafhus_1-1632497842110.png

Is there a way to achieve this using a chart expression?

1 Solution

Accepted Solutions
rubenmarin

Hi, you can using an expression like:

Sum({<Date={"$(=Max({<Planned={N}>} Date))"},Planned={N}>} Tons)

Maybe you need the add a date format:

Sum({<Date={"$(=Date(Max({<Planned={N}>} Date),'M/D/YYYY'))"},Planned={N}>} Tons)

View solution in original post

1 Reply
rubenmarin

Hi, you can using an expression like:

Sum({<Date={"$(=Max({<Planned={N}>} Date))"},Planned={N}>} Tons)

Maybe you need the add a date format:

Sum({<Date={"$(=Date(Max({<Planned={N}>} Date),'M/D/YYYY'))"},Planned={N}>} Tons)

View solution in original post