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

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression issue

Hi,

I need to write the expression for Sum of Top 5 order value by orderID in Text object

Labels (1)
2 Replies
sunny_talwar
MVP
MVP

May be like this:


Sum({<OrderID = {"=Rank(Sum([OrderValue])) <= 5"}>}OrderValue)

Kushal_Chawda
MVP
MVP

=sum({<OrderID ={"=rank(sum(OrderValue),4) <=5"}>}OrderValue)