Having trouble aggregating

[jleefjcapital]

I've attached the QVF along with a screenshot of output. 

Middle Atlantic_COLI is the new aggregate measure (grouping of three states).  I would like to simply output the average of these three states.   I'm not sure what dimension to use.  There is no date dimension.

Thanks again, Sunny.

[sunny_talwar]

I would like to simply output the average of these three states.  I'm not sure what dimension to use.  There is no date dimension.

Average of the three states? I am not sure I follow you Jes... can you please elaborate?

[jleefjcapital]

I'd like to average the indexes of each state to get a single aggregate output.  

[sunny_talwar]

Based on your snapshot

What is wrong with this output? Avg of 131, 121.9, and 101.4 is 118.1... what is the issue?

[jleefjcapital]

I would like to organize it by region (Middle Atlanta, South, Pacific) and output  only the averages by Region. 

Middle Atlantic     118.1

South                   100

Pacific                  150

Qlik sense is currently not reading the regional groupings as a dimension. 

[sunny_talwar]

If I may ask, why are you doing this in your script?

State_COLI:

Generic Load COLI_2016, State, COLI_2016

Resident COLI;

Why do you need a Generic Load here?