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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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

2 Replies
sunny_talwar

May be like this:


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

Kushal_Chawda

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