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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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