Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilgarg
Specialist
Specialist

What happen if we use 'Only' Keyword after 'ADD' or 'Replace' ??

Hey,

What happen if we use 'Only' Keyword after 'ADD' or 'Replace' ??

Thanks

6 Replies
geert_gelade
Creator
Creator

From the reference manual:

"only is an optional qualifier denoting that the statement should be disregarded during normal (non-partial)

reloads."

nikhilgarg
Specialist
Specialist
Author

HEy , do you mean to say the following:

During normal reload, this statement is disregarded(means not executed and has no effect).

During partial reload, any QlikView table previously named Tab1 is initially dropped. Thereafter new data is loaded from File1.csv and stored in Tab1.

Please tell

Thanks

geert_gelade
Creator
Creator

The table is not dropped during partial reload

for example:

Table1:

LOAD * INLINE [

    ID1

    1

    2

    3

    4

    5];

Table1:

add only load * INLINE [

    ID2

    1

    2

    3

    4

    5];

If you do a normal reload, Table1 will be created.

If you do partial reload afterwards, Table1-1 will be created and first Table1 remains.

After a normal reload again, only Table1 will be created.

nikhilgarg
Specialist
Specialist
Author

HEy,

I totally agree what you saying is correct. It is behaving in the same manner. But

1: Why it is behaving in this manner ??

2:  When i do Ctrl+Shift+R on edit script , No table1-1 is created. But when i click Partial reload from dashboard, Table1-1 is created. Why is it so??

Please tell.

Thanks.

geert_gelade
Creator
Creator

Why: when you reload, the part with partial reload is not executed (due to the "only").

On partial reload, only that part is executed and the table is added.

It seems partial reload is not working with the shortcut in the editor screen.

nikhilgarg
Specialist
Specialist
Author

Yeah , partial reload does not work i think on editor screen although on pressing , ctrl+shift+R a window with script execution opens.