I've used pivot table in some qlik designed projects. My question is about the behavior of this type of chart when it want to gets data from a table in a database. it reads all the data eagerly or it gets it when the user expands the nodes of this widget. The summarized question is how can I make the pivot table lazy when my data is too big?