there is no default number of rows, the chart will contain all rows returned by your expression if any
and the number of rows and columns that are displayed are only dependent on the height and width of the chart respectively, and that is for you to scale
Vineeth Pujari If a post helps to resolve your issue, please accept it as a Solution.
I have a table with 109288 records and 89 columns. If I create a table box and add all the columns, the chart is getting displayed properly, whereas if the same thing is added into a straight table, it gives"Out of Object Memory" error on QV Desktop itself.
Your object hit the inbuilt RAM limitations for objects. AFAIK there is no practically way to bypass it (in earlier releases there was an option to customize it). This meant you need to reduce your table in regard to the available rows, columns and/or the content (for example replacing descriptive fields with their numerical ID's) - maybe just splitting it into several tables.
Beside them such big tables makes not much sense for an user within the gui - therefore I assume the purpose of it is to export the data. Maybe this could be replaced with a store-statement within the script.
How you are creating straight table? make sure you are using proper aggregation functions in expression of straight table. May be your expressions are complicated so try to optimize the expressions
Like are using any expression while creating straight table / pivot table.
Also make some selection like month , year or city and then create chart. So that It will allocate only required memory.
If you are just adding field like table box then it will not make any issue.
Regards,
Great dreamer's dreams never fulfilled, they are always transcended. Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
