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: 
Not applicable

Error in modifier set expression

Hi,

I still don't understand all the secrets of set analysis sintaxis.

How to write this function into a set correctly?

08-06-2013 9-52-26.png

Thanks

Labels (1)
1 Solution

Accepted Solutions
swuehl
Champion III
Champion III

Set analysis is like a selection in the context of the aggregation function its embedded in. You can only select in fields, so left from the equal sign must be a field name only.

Try

=sum({<M_Account.Spanish_desc = {"H*"} >} Importe)

View solution in original post

1 Reply
swuehl
Champion III
Champion III

Set analysis is like a selection in the context of the aggregation function its embedded in. You can only select in fields, so left from the equal sign must be a field name only.

Try

=sum({<M_Account.Spanish_desc = {"H*"} >} Importe)