Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
s4ni9r
Contributor III
Contributor III

FirstSortedValue giving Nested Aggregation Error

Item URL Style Sales
10012 Image1 NY30 1000
10013 Image2 NY30 550
10014 Image3 NY30 4000
10015 Image4 NY30 3000
10016 Image5 NY30 10000
10017 Image6 NY30 450
10018 Image7 NY30 360
10019 Image8 NY30 4000
20019 Image1 NY50 4000
20019 Image2 NY50 95000
20019 Image3 NY50 1323
20019 Image4 NY50 11200
20019 Image5 NY50

7689

 

I need the image corresponding to the maximum sales for each style, i have written an expression

FirstSortedvalue(URL,-Aggr(sum(sales),Style,Item)) -- this is giving nested aggregation error as i am using this in another expression.

Can we get the same logic in script  like this FirstSortedvalue(URL,-Aggr(sum(sales),Style,Item)).

Can anyone please help..

Labels (1)
0 Replies