Syntax/trouble-shoot partial

[Akiko1]

I am in Qlik Sense Hub and I have a button on my sheet with the action of Reload data and Partial reload checked.  When I click on Button on the sheet, I can tell it's doing something (button grays and then ungrays) but I do not see the additional data (I expected to load) when I look at the sheet.  I have ran debugger but that works when I click on the load button in debugger but I haven't figured out how to troubleshoot from the sheet.    I appreciate any suggestions on how to debug and if my syntax is correct in the data load editor.  

In Data Load Editor

Lib connect oracledb (to oracle database)

JRNLLN:

LOAD

ACCOUNT, PRODUCT, MONETARY_AMOUNT;

SQL Select ACCOUNT, PRODUCT, MONETARY_AMOUNT from PS_JRNL_LN WHERE LINE_DESCR = 'ABC123' AND ACCOUNT = '123456' AND PRODUCT = '01ABC';

IF IsPartialReload() = -1 Then

Concatenate

Add Load

ACCOUNT, PRODUCT, MONETARY_AMOUNT;

SQL Select ACCOUNT, PRODUCT, MONETARY_AMOUNT from PS_JRNL_LN WHERE LINE_DESCR = 'ABC456' AND ACCOUNT = '234567' AND PRODUCT = '02ABC';

Endif;

[MendyS]

@Akiko1 

first - the syntax doesn't look like Qlik syntax,
let me try to understand better,
Do you try to load from Data Load Editor inside the app?

[Akiko1]

Yes, I am loading from Data Load Editor in Qlik Sense(app), if the syntax is 

 IF IsPartialReload() = 0 Then

and I click on the load button from data load editor  page, it loads the data.  I even tried

 IF IsPartialReload()<> 0 Then

and clicked on the button on the sheet (with the action of Reload data and Partial reload checked)  and it still does not load the data.

[MendyS]

Hi @Akiko1 
are you using QLIK in the cloud or on-premise?

[Akiko1]

on-premise.

[MendyS]

Hi  @Akiko1 

there is no "Built-in function" in QLIK called  isPartialReload - you can read how to do that here - How to perform a partial reload in Qlik Sense - Qlik Community - 1711766