How to get latest data in Qlik Sense

[GraceGao]

Hi Experts

Is there any way to get latest data in Qlik sense?   I would like to expect get 202002 yearmonth's price by product. In other words, that's get latest year month price per product. Please help. Thanks.

Examples:

                 YearMonth   Product     Price

                 202001            a                  37.5

                 202002             a                   40

[Vegar]

Try something like this. 

Aggr (only({<[YearMonth] = {'$(=max([YearMonth]))'} >}Price), Product)

PS: you can skip the aggr if you are using Product as a dimension in your chart object. DS