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: 
Not applicable

How can I select the date (Year-Month) of the last register of one ID that it´s bigger than 0 (there are registers with zeros).

Im trying to show the date of the last register (the variable is AUM) of a specific ID (Rut) with an amount bigger than zero.

debito.png

This is the original data.

debito.png

Last month with movement (Ultimo Mes con Movimiento) is the variable that I need to create, but that brings mi the bigger Year-Month including the Zeros. How can I introduce that filter? Thanks.

0 Replies