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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
bryan_21
Contributor III
Contributor III

Set Analysis

Hello how can I make my set analysis work coz I'm getting an error? I have this sample below

Sum( Qty * [Price])

Price is also computed using set analysis.

 

Thanks!

Labels (1)
1 Solution

Accepted Solutions
marcus_sommer

You mean Price isn't a field else an expression with an included set analysis which also means that it's based on an aggregation-function? In this case it would mean that you are nesting aggregations without using an aggr() because Price doesn't return the expression-result else it's just a reference to the expression behind it.

Did you try it in this way:  Sum((Qty) * [Price]

- Marcus

View solution in original post

1 Reply
marcus_sommer

You mean Price isn't a field else an expression with an included set analysis which also means that it's based on an aggregation-function? In this case it would mean that you are nesting aggregations without using an aggr() because Price doesn't return the expression-result else it's just a reference to the expression behind it.

Did you try it in this way:  Sum((Qty) * [Price]

- Marcus