topic Re: Allocated memory exceeded in QlikView

Allocated memory exceeded

Mon, 10 Mar 2014 10:27:04 GMT

Hi,

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

anyone have idea?

Re: Allocated memory exceeded

Mon, 10 Mar 2014 10:32:18 GMT

Might be something like attached.

Re: Allocated memory exceeded

Gysbert_Wassenaar — Mon, 10 Mar 2014 10:36:52 GMT

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.

Re: Allocated memory exceeded

Mon, 10 Mar 2014 10:38:02 GMT

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 Time	Delayed	Grand Total
CIVIL		2	4	6
ELEC		50	41	91
ENGP		8	6	14
INST		59	29	88

Re: Allocated memory exceeded

Mon, 10 Mar 2014 10:42:14 GMT

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

Gysbert_Wassenaar — Mon, 10 Mar 2014 11:02:55 GMT

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.

Re: Allocated memory exceeded

Mon, 10 Mar 2014 11:04:08 GMT

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.