topic Re: display max date value for each month histogram in App Development

display max date value for each month histogram

qlik99 — Wed, 03 Nov 2021 09:55:25 GMT

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;

Re: display max date value for each month histogram

qlik99 — Fri, 05 Nov 2021 14:08:06 GMT

Hello,

Any help please ?

Thanks

Re: display max date value for each month histogram

qlik99 — Tue, 23 Nov 2021 15:52:21 GMT

Any idea please ?

Regards

Re: display max date value for each month histogram

qlik99 — Tue, 23 Nov 2021 16:46:19 GMT

the solution is here :

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