Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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