Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
s4ni9r
Contributor III
Contributor III

Set Analysis Help

Could you please correct the below Set Analysis expression.

only({<URL={"=Rank(Sum(Sales),4,2)=1"}>})

Labels (1)
3 Replies
vinieme12
Champion III
Champion III

you are missing the field that ONLY() should be returning

only({<URL={"=Rank(Sum(Sales),4,2)=1"}>}   RETURNfield )

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
s4ni9r
Contributor III
Contributor III
Author

Sir, 

Could you please help me, i am in deep trouble.

s4ni9r_0-1652273584067.png

i want the image of the Maximum sales for each Style, in this case

Image5 for NY30 and Image2 for NY50.

Could you please help, i tried with FirstSorted this was giving Nested Aggregation as i am using this in another expression.

 

s4ni9r
Contributor III
Contributor III
Author

i tried with 

only({<URL={"=Aggr(Rank(Sum(Sales),4,2),Style,Item)=1"}>}URL) , but was not giving the correct result,

Any help Sir, please kindly help