Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jleefjcapital
Creator II
Creator II

I would like to create a measure

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.    

8 Replies
sunny_talwar

May be this

RangeAvg(Sum([New York]), Sum([New Jersey]))

jleefjcapital
Creator II
Creator II
Author

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? 

sunny_talwar

May be this

The Generic Load

jleefjcapital
Creator II
Creator II
Author

Can I use this in Qlik Sense? 

sunny_talwar

Sure

jleefjcapital
Creator II
Creator II
Author

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

sunny_talwar

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....

jleefjcapital
Creator II
Creator II
Author

I'll have to attach to a new post.   I'm not able to attach anything to these replies.