Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to create a measure showing averages of three measures. I tried : Avg(sum[New York], sum[New Jersey])) and it did not work.
May be this
RangeAvg(Sum([New York]), Sum([New Jersey]))
Hi Sunny,
I realized that before I can average across states, I need to order the data set. Currently, the data are organized with a State column associated with an Index column.
State Index
Mississippi 85.9
Arkansas 87.1
Michigan 89
Oklahoma 89.2
I would like to create a separate field for each state. Is there an efficient way to do this using the crosstable function?
May be this
Can I use this in Qlik Sense?
Sure
It worked, but I'm having trouble assigning the correct dimension for this newly created aggregate.
I thought "Index" would be the natural dimension, but when I use this as a dimension, the created measure is broken out into the subcomponents.
I'm not sure what I'm doing wrong.
This is how I'd like to view the data :
Index
[Middle Atlantic States] 118.1
[Pacific States] 90
[New England States] 131
Currently, I'm getting :
Index [Middle Atlantic States]
101.4 101.4
121.9 121.9
131 131
I don't know what you want and neither do I know what you are getting right now . Unless you are able to share a sample or script or images... I won't really know what is that you are getting... and after that may be explain what is that you want....
I'll have to attach to a new post. I'm not able to attach anything to these replies.