Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pljsoftware
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
sunny_talwar

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

View solution in original post

4 Replies
sunny_talwar

Check the attached (used FirstSortedValue) function

pljsoftware
Creator III
Creator III
Author

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

sunny_talwar

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

pljsoftware
Creator III
Creator III
Author

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