Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Partial Reload Help!

Hello All,

I'm having an issue with Partial Load or it may be just my lack of understanding.  I am trying to join a table from another database with this NoteA table which contains an inputfield.  When I run a partial reload in this scenario I get the same dataset (looking in the CTRL+T table preview) even if I edit some data on the back end SQL tables, I've tested around and even used replace but still no new data.  How can I get the new data loaded into my file without refreshing wholly which would take an extended period of time?  Thanks!

IF IsPartialReload() THEN

     DROP TABLE NoteA;

END IF;

NoteA:

LEFT JOIN (DName)

ADD SQL

SELECT NoteA

FROM TableA

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Partial Reload Help!

I'm not absolutely sure but I think you need to include the load of the table DName within the partial load to be able to perform the join.

- Marcus

Highlighted
Creator III
Creator III

Re: Partial Reload Help!

my first thought  will be export data from SQL and Create QVD and work with this as working on SQL Script in QLikview in confusing and you should not to mix them .

Good idea is to add your app to post as its easier to help if we can see all contest

Anna

Highlighted
Specialist II
Specialist II

Re: Partial Reload Help!

I think you need to do this:

IF IsPartialReload() THEN

LEFT JOIN (DName)

NoteA:

REPLACE

load *

;

SQL SELECT NoteA

FROM TableA;

END IF;