Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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