topic Re: partial reload not working in QlikView

partial reload not working

Tue, 13 Jan 2015 08:47:44 GMT

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

Re: partial reload not working

tresB — Tue, 13 Jan 2015 09:07:49 GMT

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

Re: partial reload not working

Tue, 13 Jan 2015 09:10:22 GMT

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>

Re: partial reload not working

tresB — Tue, 13 Jan 2015 09:24:18 GMT

Are qvds for yesterday there? Try loading them seperately.

Re: partial reload not working

Tue, 13 Jan 2015 09:39:46 GMT

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>