Max Date based in max Vol

[Chishndz]

Hello guys i need some help

I have this info:

How i can filter the max value in the same date, i try this

Max( {< Vol = {">$(=(Max(Vol)))"} >} Fecha)

but the result is negative

Thx for all the help you can give me

[Chishndz]

Correction

the formula i use is 

Max( {< Vol = {"=$(=(Max(Vol)))"} >} Fecha)

[Kashyap_R]

Hi

Try this

Max(Aggr(Max(Vol),Fecha))

Hope it helps

Thanks

[Chishndz]

It works, but i have to change the colum fecha using Max(Fecha) 

Thx a lot

[Chishndz]

Is not working as expected

generate many nulls when i don't select a material 

and when in the same day that material have the same Vol show me like null

[Kashyap_R]

Hi

try this

Max(Aggr(Max(Vol),Fecha,MaterialName))

Note: In addon uncheck the Zero Value

If  it doesn't work can u please send me the QVF I will try and get back to u

Thanks

[Kushal_Chawda]

try below

=if(aggr(if(rank(total max(Volume),0,4)=1,Date),Date) = max(total Date), max(Volume))

[Chishndz]

Sorry guys as usual the KeyUser change the way to calculate the field 'Fecha', now he wants to see the next min day of Vol staring for the actual day

this is my data

03-01-2020

04-01-2020

06-01-2020

09-01-2020

13-01-2020

14-01-2020

16-01-2020

i use 

min( {< Fecha = {">$(=((today())))"} >} Fecha)

and the result is 

13-01-2020

14-01-2020

16-01-2020

but i want to show just 

13-01-2020

Thanx for all the help and I'm sorry for the inconveniences

[Kushal_Chawda]

Where are you trying this? Can you share sample app to look at?

[Chishndz]

Here is the data

This is the result i get using the set analysis formula

  min( {< Fecha = {">=$(=((today())))"} >} Fecha)

And the date must be 13-01-2020, it depens of the date example iis today is 15-01-2020 the date i want to see is the next min day ( 16-01-2020 )

Thx for all the help