Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
waqasshah
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
sergio0592
Specialist III
Specialist III

Hi,

Try to add expression in yout chart with :

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

Try like:

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

 

Brett_Bleess
Employee
Employee

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.