topic Re: I would like to create a measure in App Development

I would like to create a measure

jleefjcapital — Wed, 12 Apr 2017 18:49:59 GMT

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.

Re: I would like to create a measure

sunny_talwar — Wed, 12 Apr 2017 18:51:46 GMT

May be this

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

Re: I would like to create a measure

jleefjcapital — Mon, 24 Apr 2017 16:03:13 GMT

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?

Re: I would like to create a measure

sunny_talwar — Mon, 24 Apr 2017 16:14:40 GMT

May be this

The Generic Load

Re: I would like to create a measure

jleefjcapital — Mon, 24 Apr 2017 18:55:17 GMT

Can I use this in Qlik Sense?

Re: I would like to create a measure

sunny_talwar — Mon, 24 Apr 2017 18:57:42 GMT

Sure

Re: I would like to create a measure

jleefjcapital — Mon, 24 Apr 2017 22:25:23 GMT

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

Re: I would like to create a measure

sunny_talwar — Tue, 25 Apr 2017 09:24:15 GMT

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

Re: I would like to create a measure

jleefjcapital — Tue, 25 Apr 2017 19:48:01 GMT

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