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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
saumyashah90
Specialist
Specialist

Sort and get minimum name for the value

PrevpagenextpageHits
ABC1231
ABC2341
ABC4551
DEF3451
DEF1231
DEF2341
EFG7892

Here I want to get Name of prev page whose Sum(hits) is max and min

I tried using

=only({<prevpagename={"=rank(Sum(Hits))=1"}>}prevpagename)  for max  output-> EFG

=only({<prevpagename={"=rank(-Sum(Hits)=1"}>}prevpagename)  for min   no output

Here when we get minimum we have 2 values for prevpage whose sum(Hits) is minimum.. I want to get one .

Is there anyway to sort it and get the value

Remember i want to get this in Text box and not in straight table or pivot.

Basically it gets confused in what to take/ Is their any way if we can sort it and get the minimum one.Any way?

1 Reply
saumyashah90
Specialist
Specialist
Author

Any try?