Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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)))