Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight table and what to SUM() what is selected within a list box. However, within the list box is only each divisions name, such as Finance, HR, etc. When I originally imported my data from each division I used qualify, thus for a given metric such as PLAN, the field is named Finance.PLAN or HR.PLAN. Thus within my straight table I want to sum PLAN and FORECAST individually. In order to do this I have written the following, however I keep getting an error message that states: Error: Error in expression: Nested aggregation not allowed. Is there anyway to script what I'm trying to do?
=Sum(Concat(getfieldselections([Divisions])&' .Plan'))
Engineering Data.Metric
Engineering Data.Plan
Engineering Data.Actual
.
.
.
.
Dixie Chopper Data.Metric
Dixie Chopper Data.Plan
See attached files.
let me know if you have any questions
Perfect, well done.
Happy Qliking.
Nice one. Thank you.