Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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