getting different number of recors in app sheet and qlik automation

[riyak17]

i am using an automation to fetch the receipt table data from my sheet for current receipt month. when i am applying the filter in the sheet using the same field and choosing 2026-06 it is showing around 54 rows but when same thing i am trying to filter in the automation using a variable in the sheet called current month which fetches the current month year . then i am using the same variable in my automation filter. but i am getting the error as error:Object data can't be bigger than 100.000 cells. 

[Andrea_Bertazzo]

Hi @riyak17 
I see that you are setting a value for the variable. It seems that this is not enough to apply a selection in your app. Instead of using a variable, I would rather directly apply the selection using an "Apply selection to report" or an "Apply selection to sheet" block.
This video could be a good example.

[riyak17]

Hi @jasonmiller11tt234 thanks for your reply .
when i am using this same current month filter with other apps it is working fine