Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
saumyashah90
Specialist
Specialist

Simple set expression needed

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

2 Replies
Gysbert_Wassenaar

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

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

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


talk is cheap, supply exceeds demand
saumyashah90
Specialist
Specialist
Author

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