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

Announcements
Join us in Toronto Sept 9th 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