display max date value for each month histogram

[qlik99]

Hello, 

I have a question , I need to display the max date value because now for example i have 3 dates in October and in the  histogram he do the sum of 3 values of Octobre 

I used this code but it doesn't works : 

left join (Table)

Load

Max(refresh_date) as refresh_date,
Month_refresh,

1 as SetAnalysisFlag

resident Table

group by Month_refresh;

[qlik99]

Hello,

Any help please ? 

Thanks 

[qlik99]

Any idea please ?

Regards 

[qlik99 · Accepted solution]

the solution is here : 

https://community.qlik.com/t5/QlikView-App-Dev/max-day-of-every-month/m-p/1087802