Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlikuser09
Creator II
Creator II

nested aggr not allowed

=Sum(if(Aggr(Min(Month([Access Date])), [UserID])= Month(AddMonths(Max(Date),-1)),1,0))

 

I'm trying to get the count/Sum of the above-mentioned function but it throws me an error

1 Reply
stevejoyce
Specialist II
Specialist II

Is your max date supposed to be a global maximum date?  Can you try 

$(=Month(AddMonths(Max(Date),-1)))