- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I'd like to average the indexes of each state to get a single aggregate output.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?