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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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