Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

partial reload not working

Hello all,

I have a slight problem.

Everything was working fine, and suddenly without any reason now it is not

Here is my code:

Let vActualYearAndMonth  = Year(now()) &'_'& num(Month(now()),'00');

let yesterday = date((Today(1)-1),'YYYY_MM_DD');

if IsPartialReload() then

[Table_PRELOAD]:

add

LOAD field1, field2

D:\New folder\$(yesterday)*(qvd);

ENDIF;

Set Path= D:\New folder\$(vActualYearAndMonth)*.qvd;

[Table_PRELOAD]:

LOAD field1, field2

From [$(Path)](qvd);

Do you have an idea, why is this suddenly not working?

Thanks in advance

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: partial reload not working

All working

Best Regards,

FIEGE BI CoC

Nemanja Momic

BI CoC Administrator

FIEGE Logistik Mönchengladbach GmbH

Regioparkring 14

41199 Mönchengladbach

Tel: + 381 11 4049821<tel:%2B%20381%2011%204049820>

Skype : nemanja.momic.get

E-Mail : nemanja.momic@fiege.com<https://outlook.fiege.com/owa/redir.aspx?C=umS-tJd99UqaVANW5aJcS410PNozEtEIuEphG1EaL3b75L2AySYhZM5NUr4eZeBAVJKxZaC0NGc.&URL=mailto%3amirjana.matovic%40fiege.com>

Web: http://www.fiege.de<https://outlook.fiege.com/owa/redir.aspx?C=umS-tJd99UqaVANW5aJcS410PNozEtEIuEphG1EaL3b75L2AySYhZM5NUr4eZeBAVJKxZaC0NGc.&URL=http%3a%2f%2fwww.fiege.de%2f>

4 Replies
MVP
MVP

Re: partial reload not working

How is the behavior, throwing any error, stopping at certain line during debug?

Not applicable

Re: partial reload not working

Hello,

There is no error, it just wont show data for yesterday in any chart.

When I take out the Partial part, it works fine, everything is there.

Best Regards,

FIEGE BI CoC

Nemanja Momic

BI CoC Administrator

FIEGE Logistik Mönchengladbach GmbH

Regioparkring 14

41199 Mönchengladbach

Tel: + 381 11 4049821<tel:%2B%20381%2011%204049820>

Skype : nemanja.momic.get

E-Mail : nemanja.momic@fiege.com<https://outlook.fiege.com/owa/redir.aspx?C=umS-tJd99UqaVANW5aJcS410PNozEtEIuEphG1EaL3b75L2AySYhZM5NUr4eZeBAVJKxZaC0NGc.&URL=mailto%3amirjana.matovic%40fiege.com>

Web: http://www.fiege.de<https://outlook.fiege.com/owa/redir.aspx?C=umS-tJd99UqaVANW5aJcS410PNozEtEIuEphG1EaL3b75L2AySYhZM5NUr4eZeBAVJKxZaC0NGc.&URL=http%3a%2f%2fwww.fiege.de%2f>

MVP
MVP

Re: partial reload not working

Are qvds for yesterday there? Try loading them seperately.

Not applicable

Re: partial reload not working

All working

Best Regards,

FIEGE BI CoC

Nemanja Momic

BI CoC Administrator

FIEGE Logistik Mönchengladbach GmbH

Regioparkring 14

41199 Mönchengladbach

Tel: + 381 11 4049821<tel:%2B%20381%2011%204049820>

Skype : nemanja.momic.get

E-Mail : nemanja.momic@fiege.com<https://outlook.fiege.com/owa/redir.aspx?C=umS-tJd99UqaVANW5aJcS410PNozEtEIuEphG1EaL3b75L2AySYhZM5NUr4eZeBAVJKxZaC0NGc.&URL=mailto%3amirjana.matovic%40fiege.com>

Web: http://www.fiege.de<https://outlook.fiege.com/owa/redir.aspx?C=umS-tJd99UqaVANW5aJcS410PNozEtEIuEphG1EaL3b75L2AySYhZM5NUr4eZeBAVJKxZaC0NGc.&URL=http%3a%2f%2fwww.fiege.de%2f>

Community Browser