Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

aggr selection issue

Hi,

when using calculated dimension with aggr it select the user,

here is my dimension:

=Aggr(FirstSortedValue(vp, -Date), user)

can i make it select the vp?

the result in the table is correct.

please find attached qvf

thanks.

ido.

Capture.PNG

1 Reply
Partner
Partner

hi 

use this expression :count(aggr( if(Date = max(total<user> Date), user),user,vp))

with vp as your dimension