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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis with aggregate

I am using an aggregation function in which i want to include set analysis for the previous year and am struggling a little bit. the expression which does not work is

=-sum( {$<[Year-RCV] = {$(=Min([Year-RCV])-1)}>} aggr([Transit Time] >= ([Receipt Date] - [Ship Date]),[Doc. Number]))

am using the same set analysis to count in another expression and it works. the working expression is

=count({$<[Year-RCV] = {$(=Min([Year-RCV])-1)}>} distinct [Doc. Number])

0 Replies