topic Re: Latest Record on Straight Table in QlikView

Latest Record on Straight Table

pljsoftware — Thu, 16 Feb 2017 13:02:42 GMT

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].

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

Re: Latest Record on Straight Table

sunny_talwar — Thu, 16 Feb 2017 13:10:38 GMT

Check the attached (used FirstSortedValue) function

Re: Latest Record on Straight Table

pljsoftware — Thu, 16 Feb 2017 13:37:08 GMT

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

Re: Latest Record on Straight Table

sunny_talwar — Thu, 16 Feb 2017 13:43:27 GMT

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

Re: Latest Record on Straight Table

pljsoftware — Thu, 16 Feb 2017 17:52:30 GMT

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