Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
prathapkoti
Contributor
Contributor

Filter the aggregate data from qlikview associated Data on Event Trigger

I have a typical problem of filtering out the Aggregated data of the Maximum value after grouping the filtered data and display the Aggregate Data like for e.g. Max on the associated data on dynamic basis. Need help to code it on button click event.

 

Attached is the files associated with my trial.

 

All that I need is to group by Department and get the data where "Max(Joined Date)" is equal to "Joined Date" value (without group by).Means in each department i need the employee with Max Joining Date or the most recently joined Employee.

 

Thanks in Advance..!

Labels (4)
1 Reply
Brett_Bleess
Former Employee
Former Employee

Couple of Design Blog posts that may be of some help:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Sorry I cannot be of more direct help, this post will re-kick things, so someone else may chime in as well.

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.