I just ran into this problem too, not a lot of data in the table where it just won't load
Edit: This has been happening since we updated to 3.1. We were running 2.0 prior to this and not experiencing the problem.
After 10-15 minutes, it gives up. This is a major problem for us as we are about to deploy production Apps to our operation, and we are only experiencing this issue since we updated to 3.1 last week. We were running tables with hundreds of thousands of rows, with fairly little issue, but now I can't load a couple thousand. I cannot navigate the filter panes because the dimension choices will not even show up, so now we have no data loading.
Nothing has changed in our Qlik Sense Server set up within the past week. We have had Qlik Sense Server deployed for a year and a half, and this issue rarely appeared. Is there any reason why this would be occurring?
There is many things you can improve.
- what is a dimension in your table (field or calculated dimension)?
- what is your expression
- does your expression use data island calendar
- Is it maybe "=sum(If...)" expression?
- How is your model build - does your expression have to run through all rows in your fact table or you can use set analysis to pre-filter rows only to those which have to be calculated.
Can you screenshot your datamodel and highlight where are all components coming from ?
Maybe QlikSense seems to be easy tool to use, but performance tuning requires knowledge on how to make all expressions/objects responding fast.
We will take it from there.