Get the total count of Cells from Get Straight Table Data

[kaushiknsolanki]

Dear Team,

In one of my Application Automation i am trying to export Qlik Chart Data in to Excel, but the block "Get Straight Table Data" has the limit of 100,000 cells.

So wanted to know if there is any way to know total cells in the Qlik Straight Table.

Any help is appreciated.

Regards,

Kaushik Solanki

[Rf2]

Hello @kaushiknsolanki

I had similar issue. I think you could use the Variable click "Manage Variable" and add new name with Number type.

See below image might help :

[kaushiknsolanki]

Dear @Rf2 I have already tried this, the issue is when for one selection when the number of cells is above 100,000 the block gives error and for that the variable doesnt show the count.

[Rf2]

@kaushiknsolanki sorry I could not help, hope we get a reply with a solution