I have one straight table and it has almost 20 expression and 6 dimension previously in that have cyclic group for all dimension but my client requirement is they don't want cyclic group instead of that they want buttons for that table.
so i removed that group and create 6 button for all dimension and put hide and show formula on that.
but problem is that when i am doing dimension limit 20 for each dimension then i get error "allocated memory exceeded".
Now i want to remove that error and want top 20 reorcds from all dimension.
yes , its possible. Are you using calculated dimensions? if so try to push those to script because this kind of error occurs when qlikview has to perform lot of calculation in the front end. And check whether the columns are all linked i.e you have not included any orphan columns