Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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