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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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?