Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Sally3
Contributor III
Contributor III

LastValue

Hi 

I wanted to write a script for getting the last Critical, Major value...Based on Date (Last appeared value of each category on a recent date)

As shown below :

1 Reply
Thiago_Justen_

Hi there,

What about this?

 

Final_Table:

Load

        Category,

         LastValue(Date)   As Date,

         LastValue(Major) As Major,

         LastValue(Critical) As Critical

Resident Origin_Table

          Order By    Category Asc;

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago