Allocated memory exceeded after using set anaysis

[DA333DATA]

(using QlikView version 11)

using simple set analysis and following this guide: 

https://www.resultdata.com/using-multiple-alternate-states-combined-with-set-analysis-to-create-a-co...

My Steps

dataset is only 20 lines

in a column chart use expression sum(Sales) - works fine

when change to sum({country state 1}Sales) get error allocated memory exceeded

(country state 1 was created based on Alternate States)

is there any workaround?

is there any problem with the syntax?

[jonathandienst · Accepted solution]

I have never used an alternate state with spaces in the name. I would rename the state without spaces (eg CountryState1), or wrap the name in square brackets:

Sum({[country state 1]} Sales)

[DA333DATA]

thanks - naming the state without spaces worked.
wrapping it within square brackets didnt work.

[jonathandienst]

---

@DA333DATA wrote:
wrapping it within square brackets didnt work.

---

I was not sure about that one, thanks for confirming that is is not the solution.