Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

prma7799
Honored Contributor III

issue with straight table

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

1 Solution

Accepted Solutions
MVP
MVP

Re: issue with straight table

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
6 Replies

Re: issue with straight table

Can you post a qlikview document that demonstrates the problem?


talk is cheap, supply exceeds demand

Re: issue with straight table

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

MVP
MVP

Re: issue with straight table

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
antoniotiman
Honored Contributor III

Re: issue with straight table

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
Honored Contributor III

Re: issue with straight table

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?

MVP
MVP

Re: issue with straight table

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser