Lowest value of the last aggregated date per product

[HnLima]

I need to bring the lowest value of max(Data) per product, I have a table with the information:

table:
Products,
Date,
Price,
other areas...;

I will send a print to exemplify the result I want to obtain.

Thanks!

#QlikSense

[MatheusC · Accepted solution]

Hi, @HnLima 

Try this expression:

Min(If(Aggr(NODISTINCT Max(Date), Products) = Date, Price))

Att, Matheus

[HnLima]

Almost there, @MatheusC , brings the last price, but for the value that does not enter the condition it returns null, how can I deal with them?

[MatheusC]

Use the isnull function to handle nulls

ex:

if(isnull(expression),0,expression)

 qlik help function isnull:
https://help.qlik.com/pt-BR/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/Scripting/NULLFun...

[HnLima]

@MatheusC 
Thank you for your attention, it worked very well