topic Re: Choose MAX value on MAX Date in QlikView

Choose MAX value on MAX Date

waqasshah — Mon, 27 Jul 2020 11:05:56 GMT

Hi Guys,

I need you help. Below is my table and in my chart I would like to display the maximum Appointment value on Maximum Date. Like I want to display 180 on 26/07/2020. how it can be achieved? Thanks

Date	Unit	Specialty	Appointments
26/07/2020	NULL	Mechanics	56
26/07/2020	BU1	Mechanics	25
26/07/2020	BU2	Mechanics	180
25/07/2020	NULL	Mechanics	10
25/07/2020	BU1	Mechanics	158
25/07/2020	BU2	Mechanics	91

Re: Choose MAX value on MAX Date

sergio0592 — Mon, 27 Jul 2020 12:51:54 GMT

Hi,

Try to add expression in yout chart with :

max(TOTAL {<Date={"=$(=max(Date))"}>} Appointments)

Re: Choose MAX value on MAX Date

tresB — Mon, 27 Jul 2020 13:00:02 GMT

Try like:

max({<Date={'$(=Date(max(Date)))'}>} Appointments)

Re: Choose MAX value on MAX Date

Brett_Bleess — Tue, 11 Aug 2020 17:35:05 GMT

You have two good responses, we would greatly appreciate if you would return to your thread and be sure to review those and if either or both answer your question, use the Accept as Solution button on the one(s) that did help. If you did something different, you can post that and then use the button on that post afterward. The marking of things gives the posters credit for the assistance and lets the other Members know what works, so please be sure to return to the thread and either mark something or leave an update post on what you still need.

Regards,
Brett