Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Latest Record on Straight Table

Hi all,

I have a record set with fields in images.

There are more [Id] and each Id have different [Element ID] and [Output Creation Date].

Latest Record on Straight Table.png

I need to create a straight table where show latest record for a each [Id], to check lastest record I test [Output Creation Date], but only for rows where [Message Type Name]TX.

The result can't be calculate in script because need to have latest for current selections.

I add QVW and Excel attach.

To check if result is correct the lines are in green and in Excel file you can find the sheet Result too.

Thanks in advance for your help.

Luca Jonathan Panetta

1 Solution

Accepted Solutions

Added the other option using if statement (expression is hidden on the presentation tab)

View solution in original post

4 Replies

Check the attached (used FirstSortedValue) function

Creator III
Creator III

Hi Sunny,

that could be a possible solution but I have more fields and I would, if possible, to don't create an expresson for each field. The number of fields enabled could be 50.

There is a possible solution with all fields in dimension and a single expression?

Thanks a lot.

Luca Jonathan Panetta

Added the other option using if statement (expression is hidden on the presentation tab)

View solution in original post

Creator III
Creator III

Hi Sunny,

thanks a lot. I don't like "IF" but I think that in this case is the only way.

Thanks

Luca Jonathan Panetta