topic Re: Having trouble aggregating in App Development

Having trouble aggregating

jleefjcapital — Tue, 25 Apr 2017 19:51:10 GMT

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.

Re: Having trouble aggregating

sunny_talwar — Fri, 28 Apr 2017 08:28:01 GMT

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?

Re: Having trouble aggregating

jleefjcapital — Mon, 05 Jun 2017 18:22:59 GMT

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

Re: Having trouble aggregating

sunny_talwar — Mon, 05 Jun 2017 19:09:14 GMT

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?

Re: Having trouble aggregating

jleefjcapital — Mon, 05 Jun 2017 19:55:55 GMT

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

sunny_talwar — Tue, 06 Jun 2017 11:16:41 GMT

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?