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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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