Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
DA333DATA
Contributor
Contributor

Allocated memory exceeded after using set anaysis

(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?

 

 

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

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)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

3 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

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)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
DA333DATA
Contributor
Contributor
Author

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


@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.Smiley Happy

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein