Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Max Date based in max Vol

Hello guys i need some help

I have this info:

info.PNG

 
 

 

 

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

 

9 Replies
Highlighted
Contributor II
Contributor II

Correction

the formula i use is 

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

Highlighted
Partner
Partner

Hi

Try this

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

Hope it helps

Thanks

Highlighted
Contributor II
Contributor II

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

Thx a lot

Highlighted
Contributor II
Contributor II

Is not working as expected

generate many nulls when i don't select a material 

null.PNG

 

 

 

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

doble.PNG

 

Highlighted
Partner
Partner

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

Highlighted
MVP
MVP

try below

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

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

 

 

 

 

 

Highlighted
MVP
MVP

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

Highlighted
Contributor II
Contributor II

Here is the data

sample 2.PNG

 

 

 

 

This is the result i get using the set analysis formula

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

sample.PNG

 

 

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