QlikView not loading all the tables (4) but loading only 2 or 3 randomly

[OmarBenSalem]

Hi all,

I have a really strange problem ! In fact, have 4 excels files, they all have one KeyDate in common; when I reload; each time only 2 or 3 tables appear ! (randomly), and the other ones are not reloaded ! I stored each table in a QVD, then loaded all 4 qvds and all 4 tables appeared ! That's the strangest thing ever !

Are you aware if there is configuration that maybe someone changed in 'user preferences or any other place that I need to check?? maybe? Thanks a lot !

and be sure, that the 4 tables are just excel ones, containing nothing strange at all. They all have one field in common. I just imported them a loaded with no further configuration..

Thanks !

[OmarBenSalem]

sthing like this:

First script:

Table 1 :

KeyDate,

otherfields1

from table1;

noconcatenate

Table 2 :

KeyDate,

otherfields2

from table2;

noconcatenate

Table 3 :

KeyDate,

otherfields3

from table3;

noconcatenate

Table 4 :

KeyDate,

otherfields4

from table4;

=> Only 2 or 3 tables are loaded (randomly)

Second script:

Each time, I comment all tables, and only leave one and then store it in a QVD:

example:

noconcatenate

Table 4 :

KeyDate,

otherfields4

from table4;

Store Table 4 into [..QVD\Table4.qvd](qvd);

I do this for the 4 tables:

and then:

noconcatenate

Load * from [..QVD\*.qvd](qvd);

And all 4 tables are loaded...

[Siva_Sankar]

Omar,

I was in a conversation for the same or almost similar kind of issue in our community. Finally came to know that the issue is with the date format.

Here is the thread...QlikView associative property is not working

May be you can try the same and see.

Thanks.

Siva