issue with straight table

[prma7799]

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

[Gysbert_Wassenaar]

Can you post a qlikview document that demonstrates the problem?

[avinashelite]

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

[jonathandienst · Accepted solution]

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.

[antoniotiman]

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

[prma7799]

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?

[jonathandienst]

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