Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

jleefjcapital
Contributor II

Having trouble aggregating

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.

5 Replies

Re: Having trouble aggregating

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
Contributor II

Re: Having trouble aggregating

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

Re: Having trouble aggregating

Based on your snapshot

Capture.PNG

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

jleefjcapital
Contributor II

Re: Having trouble aggregating

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. 

Re: Having trouble aggregating

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?