Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis in variable

I wanted to create a set analysis in an expression, but it gives me an error because a have a variable as field. Then I came with the idea to create my set analysis in a variable:

Naamloos.png

But when I show this variable in my chart, it only gives me zeros. Who can help me out?

Thanks in advance!

1 Solution

Accepted Solutions
marcus_sommer

Your variables contain aggregations which you want to use within another aggregation without the use of an aggr-function - it's quite similar to this one: Calculated variable in expression with set analysis.

- Marcus

View solution in original post

3 Replies
sunny_talwar

How do you define v_PNV and v_QTY_M3I? Are these expressions also?

Not applicable
Author

These are variables as well:

Naamloos2.png

Naamloos3.png

marcus_sommer

Your variables contain aggregations which you want to use within another aggregation without the use of an aggr-function - it's quite similar to this one: Calculated variable in expression with set analysis.

- Marcus