Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
Not applicable
Author

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>

View solution in original post

4 Replies
tresesco
MVP
MVP

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

Not applicable
Author

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>

tresesco
MVP
MVP

Are qvds for yesterday there? Try loading them seperately.

Not applicable
Author

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>