topic Re: Allocated memory exceeded after using set anaysis in QlikView

Allocated memory exceeded after using set anaysis

DA333DATA — Wed, 10 Apr 2019 05:15:00 GMT

(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-comparison-chart-part-one/

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?

Re: Allocated memory exceeded after using set anaysis

jonathandienst — Wed, 10 Apr 2019 05:24:37 GMT

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)

Re: Allocated memory exceeded after using set anaysis

DA333DATA — Wed, 10 Apr 2019 06:00:41 GMT

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

Re: Allocated memory exceeded after using set anaysis

jonathandienst — Wed, 10 Apr 2019 06:26:25 GMT

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