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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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.