Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

aggr within set expression

Hello there,

could someone please help me if it is possible to somehow replace the Orders.ListPrice_Total within the expression below with aggr(sum(Orders.ListPrice_Total),Orders.PO)?

Count({$< Orders.ListPrice_Total = {">=$(=$(V3_SmallOrderThreshold_lower))<$(=$(V1_SmallOrderThreshold))"}>} DISTINCT Orders.PO)

Regards,

Ales

1 Reply
sunny_talwar

Left hand side of the set modifiers do not allow for use of functions. May be use if statement or provide a sample with expected output so that we can help you find another way