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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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