Hi All, I have the below requirement, to show the image for each style that has max sales.
in this case, i need to show image5 for Style =30 and image2 for Style=50.
I have written my code like this : FirstSortedValue(URL,-Aggr(Sum(Sales),Style,Item)), when i use this iam getting nested aggregation error as i am using this function in another function which has sum,max.
Now, Could you please help me to acheive the same requirement in Qlik Script (FirstSortedValue(URL,-Aggr(Sum(Sales),Style,Item))
OR at the UI level, can we write the logic in different way similar to the FirstSorted logic.