Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
swazi001
Contributor
Contributor

Aggregation evaluation in Set Analysis

I am trying to perform a group by and evaluate the result in an expression. This would be a simplified version of what I am trying to achieve:

=sum( {<[Aggr(sum(amount),value_A, value_B)]={"<0"}>} amount)

 

In this expression as I have it, the <0 is ignored and the sum of all values grouped by A and B is returned.

Any suggestions?

1 Reply
Lauri
Specialist
Specialist

Is [Aggr(sum(amount),value_A, value_B)] the name of a dimension? If it isn't, then the set analysis won't work. You can only use dimensions.