Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.