topic issue with straight table in QlikView

issue with straight table

prma7799 — Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

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.

Is it possible in straight table ?

Thanks

Re: issue with straight table

Gysbert_Wassenaar — Fri, 24 Jul 2015 09:51:29 GMT

Can you post a qlikview document that demonstrates the problem?

Re: issue with straight table

avinashelite — Fri, 24 Jul 2015 09:51:42 GMT

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

Re: issue with straight table

jonathandienst — Fri, 24 Jul 2015 09:53:04 GMT

You might be better off creating 6 tables and using a conditional show based on the user's button click. Non-visible tables are not calculated, so you might get better performance with that option.

Re: issue with straight table

antoniotiman — Fri, 24 Jul 2015 09:56:18 GMT

Hi,

Yes, You can use Calculated Dimensions Like

Aggr(If(Rank(Sum(Value) <=20),Dim1),Dim1)

But, in this case You have Dimensions Hide/Show.

Regards,

Antonio

Re: issue with straight table

prma7799 — Fri, 24 Jul 2015 10:02:09 GMT

Hi Jonathan,

Thanks for reply So your opinion is that, I have to create 6 chart individual and give them hide n show condition. right?

Re: issue with straight table

jonathandienst — Fri, 24 Jul 2015 10:06:15 GMT

That's what i would try Just clone the original table 6 times and clean up the extra dimensions and set the show condition.