Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
sara_plez
Contributor III
Contributor III

Showing values just for the last day

Hello,

I´m trying to show in the following example:

Captura.PNG

Just only for the last date the relationed mode with their regions and the sum of people.

I am trying with this:

Captura2.PNG

But this is no showing the values for the last date.

The result that Im am looking for is this:

Captura3.PNG

I attached the QVW example.

Thank you,

Sara

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

Please use this expression:

sum({<Date={"$(=Date(max(Date)))"}>} People)

View solution in original post

2 Replies
Clever_Anjos
Employee
Employee

Please use this expression:

sum({<Date={"$(=Date(max(Date)))"}>} People)

maxgro
MVP
MVP

sum({$ <Date={'$(=max(Date))'}>} People)

1.png