topic Out of Memory v-9 in QlikView https://community.qlik.com/t5/QlikView/Out-of-Memory-v-9/m-p/215518#M68982 <HTML><HEAD></HEAD><BODY><P>Can you name the objects?</P><P></P></BODY></HTML> Mon, 18 Jan 2010 20:40:16 GMT 2010-01-18T20:40:16Z Out of Memory v-9 https://community.qlik.com/t5/QlikView/Out-of-Memory-v-9/m-p/215517#M68981 <HTML><HEAD></HEAD><BODY><P>Just a quick question</P><P>Objects that worked very well in version 8.5 and prior have "Out of Memory" messages in version 9</P><P>Anyone experience this? Anyone have a possible solution for this?</P><P>What perplexes me is that I though that version 9 was suppose to have a better calculation engine. I've been experiencing the oposite</P></BODY></HTML> Mon, 18 Jan 2010 18:06:53 GMT https://community.qlik.com/t5/QlikView/Out-of-Memory-v-9/m-p/215517#M68981 2010-01-18T18:06:53Z Out of Memory v-9 https://community.qlik.com/t5/QlikView/Out-of-Memory-v-9/m-p/215518#M68982 <HTML><HEAD></HEAD><BODY><P>Can you name the objects?</P><P></P></BODY></HTML> Mon, 18 Jan 2010 20:40:16 GMT https://community.qlik.com/t5/QlikView/Out-of-Memory-v-9/m-p/215518#M68982 2010-01-18T20:40:16Z Out of Memory v-9 https://community.qlik.com/t5/QlikView/Out-of-Memory-v-9/m-p/215519#M68983 <HTML><HEAD></HEAD><BODY><P>pivot table with if then expressions</P></BODY></HTML> Mon, 18 Jan 2010 20:48:31 GMT https://community.qlik.com/t5/QlikView/Out-of-Memory-v-9/m-p/215519#M68983 2010-01-18T20:48:31Z Out of Memory v-9 https://community.qlik.com/t5/QlikView/Out-of-Memory-v-9/m-p/215520#M68984 <HTML><HEAD></HEAD><BODY><P>Ah yes ... those are probably the worst kind when it comes to memory usage. Use a straight table instead when memory issues occur.</P><P>If possible, try to avoid if-statements, especially in a pivot table and ones that use texts. Try to do those calculations/statements when loading the data.</P><P>Also use SUM rather than COUNT (there are several tricks/tips for this)</P><P>There are also ways to aggregate your data before you use it in your charts.</P><P></P><P>Pivot tables look nice, but are real memory gulpers <IMG alt="Wink" src="http://community.qlik.com/emoticons/emotion-5.gif" /></P><P></P></BODY></HTML> Mon, 18 Jan 2010 21:02:38 GMT https://community.qlik.com/t5/QlikView/Out-of-Memory-v-9/m-p/215520#M68984 2010-01-18T21:02:38Z Out of Memory v-9 https://community.qlik.com/t5/QlikView/Out-of-Memory-v-9/m-p/215521#M68985 <HTML><HEAD></HEAD><BODY><P>thanks,</P><P>I guess my perplextion is that this used to work perfectly in 7.0 and 8.5</P><P>I'm going to have to add more methods to get this to work</P></BODY></HTML> Mon, 18 Jan 2010 22:23:18 GMT https://community.qlik.com/t5/QlikView/Out-of-Memory-v-9/m-p/215521#M68985 2010-01-18T22:23:18Z Out of Memory v-9 https://community.qlik.com/t5/QlikView/Out-of-Memory-v-9/m-p/215522#M68986 <HTML><HEAD></HEAD><BODY><P>I've seen intermittent strange out of object memory errors myself. I can't remember if they were always there, or if they only started appearing when we switched to the server to version 9. In my case, one of the offending charts is a straight table that displays data from a table with only a handful of rows. It has some vaguely complicated pieces, like a dual() function that strings together some fields for a calculated dimension, and one of the columns is a traffic light, and it calculates the color for the caption text and background. But seriously, nothing that would cause an actual memory problem unless there's something seriously amiss.</P><P>But I've only seen it happen a couple of times, and no one has complained, so I haven't tried to figure out what is going wrong.</P></BODY></HTML> Mon, 18 Jan 2010 22:45:21 GMT https://community.qlik.com/t5/QlikView/Out-of-Memory-v-9/m-p/215522#M68986 johnw 2010-01-18T22:45:21Z