Maximum Number of records in Straight table chart limit

[chintan1989]

Hello Friends

I am making a cross table with 23 columns and 7 lac plus records.

Result will be some 1.69 crore records.  While reload the QVW hangs with no response.

Is the above scenario possible in QlikView  with some workaround or its not possible to process 1.69 crore records in a straight table.

Any help is appreciated.

Thanks & Regards

Chintan

[marcus_sommer]

The table-charts in Qlik aren't designed to display such huge tables whereby not only the calculation of the data might be a challenge but also the rendering of the object. Therefore it may work but depending on the datamodel, the kind of calculations and the types of data you may hit any timeouts or restrictions of the object RAM.

Quite probably served this table no direct analysis else it's aimed to export the data - and this might be better transferred into the script.

- Marcus

[chintan1989]

Thanks Marcus for your reply.  

We just want to apply couple of filters on the resultant data and export the report. 

Can you please elaborate on below:

Quite probably served this table no direct analysis else it's aimed to export the data - and this might be better transferred into the script.

Thanks & Regards

Chintan

[marcus_sommer]

In general could each table which is used within the UI also be created within the script and could be stored from there as csv-file to be processed in other tools. This approach might not always be easy but by really large tables it's often the only (practically) way.

But if you don't want to export such large table else only quite smaller slices you could of course use such table whereby it would be useful to teach the users to apply at first the wanted selections before opening this table and/or to apply some visibility-conditions (tab general), like: count(distinct Dim1 & Dim2 & Dim3) < 10000 whereby Dim1 ... is here a placeholder for the used dimensions in your table.

- Marcus

[Brett_Bleess]

Marcus is definitely providing good advice here, and I just wanted to add other piece to his Condition Show, which is the Calculation Condition in the Chart Properties as well:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartProperties...

If Marcus' comments helped you get things resolved, be sure to give him credit by clicking the Accept as Solution button.  If you came up with something else, you can post that and mark it, this way others can learn from what you did as well. 

Oh, this could be just a resource issue as well, be sure where you are running things has enough memory resources to handle things.  You can use Windows Task Manager to keep an eye on things to see if you are running out of memory etc.  

Regards,
Brett