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: 
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
MVP
MVP

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
MVP
MVP

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