I have a straight table report which gives 'Calculation timed out' error. This report is working fine in dev and SIT environment but since a few days, its giving 'Calculation Timed Out' error in Prod. Once I select some filters, the report shows up but without filters, error.
I have had a look at the expressions, it has 3 of them with not much of set analysis, so calculations should not be an issue here.
I have noted that the data in the reports on a weekly basis increases randomly i.e., 1 week its only 3-4k and other week its around 50K.
I cant even find out the overall count of records in my report.
I just wanted to know that is there any number of records limitation in a straight table that Qlik has specified? If yes, please send me the link and if no, please suggest how can I resolve this.