Automation problem

[SebastianDL]

Hello

Sorry for my English, I speak Spanish.
I'm new to this automation thing.
What I am trying to do is download some data from a Qlik table to a Google spreadsheet but I get this error "Object data can't be bigger than 100,000 cells" even though I put filters.

I have followed the tutorials that I have found but the first thing I realized is that in my case the names of the variables of the table in "Hystori" do not appear, so I do it myself.

The table is this:

Applying these filters I know that the 100000 cells are not passed, I do not know why that error occurs.

Could it be that I am missing some permission? or am I doing something wrong?

[NadiaB]

Hi @SebastianDL 

From the comment about it seems you believe that the limit is not exceeded, did you proceed with any validation to ensure that the 100,000 cells are not exceeded? If not could it be verified?

If this has been validated and we have an exact number of cells and is definitely not exceeding the limit it is suggested to file a support ticket so it can be further investigated.

Kind Regards.

[Emile_Koslowski · Accepted solution]

Hi @SebastianDL ,

You need to apply selections in the automation before you execute the Get Straight Table Data block. You can do this by using the blocks Select Field Value and Select Field Values By Query. 

Selections applied in the Qlik Sense UI are not available in the automation. The reason for this is that automations use different sessions than the UI. More information on this can be found here: Session delays 

Kind regards,
Emile

[SebastianDL]

Thanks! It's what I needed.

[Napus]

Can I ask if you can send your ultimate solution, I need to do the same thing but i am very new to Qlik Automation. thanks