Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Allocated memory exceeded

Hi,

I want to show "Calculated Dimension" in Pivot table but it show "Allocated memory exceeded"

anyone have idea?

6 Replies
Not applicable

Re: Allocated memory exceeded

Might be something like attached.

Re: Allocated memory exceeded

Create a new field in the script using the expression you now try to use as calculated dimension. Then use the new field instead in the chart.


talk is cheap, supply exceeds demand
Not applicable

Re: Allocated memory exceeded

Shyamal i don't want to show like this i know pivot table show the data in this format but i want to show like..

Main Work Center=If([Priority
)))
On TimeDelayedGrand Total
CIVIL 246
ELEC 504191
ENGP 8614
INST 592988
Not applicable

Re: Allocated memory exceeded

Thank you Gysbert for your answer.

But i cant do this Both dates which are in the Script are coming from different tables and our both table are huge data if i reload again it will take huge time to reload and it will reload schedule to reload after an hour.

Re: Allocated memory exceeded

If your tables are huge I don't think you have a choice but to calculate this in the script. Create a summary table if necessary. A calculated dimension using date from two huge tables will very likely give you the error you see now. And even if it doesn't performance will likely be horrible.


talk is cheap, supply exceeds demand
Not applicable

Re: Allocated memory exceeded

Hi Adeel,

Then you need to do what Gysbert has suggested. Create this column in script and then use it in front end/chart.

The chart is going "Out of Memory" because of the huge calculation being done.

Community Browser