Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Choose MAX value on MAX Date

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 

DateUnitSpecialtyAppointments
26/07/2020NULLMechanics56
26/07/2020BU1Mechanics25
26/07/2020BU2Mechanics180
25/07/2020NULLMechanics10
25/07/2020BU1Mechanics158
25/07/2020BU2Mechanics91
    

 

 

3 Replies
Highlighted
Specialist III
Specialist III

Hi,

Try to add expression in yout chart with :

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

Try like:

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

 

Highlighted
Digital Support
Digital Support

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.