topic Simple set expression needed in QlikView

Simple set expression needed

saumyashah90 — Fri, 13 Mar 2015 08:09:32 GMT

I have

Page and der hits.

so I need to aggregate those hits and check which page got highest hits and which got min.

I need this in text box.let me know the set expression

Gysbert_Wassenaar — Fri, 13 Mar 2015 08:30:32 GMT

=only({<Page={"=rank(sum(Hits))=1"}>}Page)

=only({<Page={"=rank(-sum(Hits))=1"}>}Page)

or maybe count(Hits) instead of sum(Hits)

saumyashah90 — Fri, 20 Mar 2015 10:30:48 GMT

I have aggregated value in one column based on page.

like Sum(Hits)=TotalHitsFromPage.

I got expression for max hits

so how would set expression look like for minimum hits

BTW 2nd expression -sum(Hits) is not working