Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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?
I'd like to average the indexes of each state to get a single aggregate output.
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?
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.
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?