topic Re: Nested value error in QlikView

Nested value error

MK9885 — Thu, 15 Sep 2016 01:12:20 GMT

Hi,

I'm trying to create a set analysis function

=sum({<[Region Name]={'North America'}>}$(vOrder))

Where $(vOrder)= sum(field1)+sum(field2)+sum(field3)

If the total Order =700M and North America Total Order =170M. So I want the Total Order for only North America.

I tried the above expression and it throws me an nested agg error.

Thanks.

sunny_talwar — Thu, 15 Sep 2016 01:14:24 GMT

May be try like this:

Sum({<[Region Name]={'North America'}>} Aggr($(vOrder), <YourChartDimensionsHere>))

Replace <YourChartDimensionsHere> with the dimensions you have in your chart where you are trying to perform this calculation

MK9885 — Thu, 15 Sep 2016 01:16:33 GMT

I don't have a dimension to this. I'm trying to achieve this in a Text object.

sunny_talwar — Thu, 15 Sep 2016 01:17:57 GMT

Then try this:

Sum({<[Region Name]={'North America'}>} Aggr($(vOrder), [Region Name]))

MK9885 — Thu, 15 Sep 2016 01:21:48 GMT

I've tried it and it throws me a 0 as final result.

I know the Total Order for North America is more than 100M.

Please note: vOrder = sum(Field1)+sum(field2)+sum(field3)

sunny_talwar — Thu, 15 Sep 2016 01:24:16 GMT

How about this? vOrder without dollar sign expansion?

Sum({<[Region Name]={'North America'}>} Aggr(vOrder, [Region Name]))

Would you be able to share a sample if the above doesn't work?

sunny_talwar — Thu, 15 Sep 2016 01:29:20 GMT

Seems to be working for me in this sample

Only thing to make sure is that don't have a = sign in your variable definition. Try it without the equal sign

MK9885 — Thu, 15 Sep 2016 01:36:22 GMT

Yes, maybe I was using = while defining the variable.

The values are matching for me now.

Thanks a lot, it was very helpful.

sunny_talwar — Thu, 15 Sep 2016 01:36:46 GMT

Awesome