Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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.


This is the original data.


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.

Tags (1)
Community Browser