Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Data fully loaded, but partially displayed...

Hello everyone,

I got some troubles with the loading of some data. In certain cases, wich I don't know exactly, some of the data are not displayed, but still well loaded. An example with the Time table:

example.png

As we can see, everything is fully loaded, but two years are not displayed. There is one white case containing the two missing years.

And when I select directly '2011' for example, there is nothing displayed because it's like if the data is loaded but not as being 2011.

example2.PNG

I have this problem with two others tables. The database is Oracle. And I don't think the problem come from the script because with others tables, it works.

Any ideas?

Thank you!

EDIT:

Data Structure:

dataStructure.PNG

6 Replies
Not applicable

Re: Data fully loaded, but partially displayed...

could you send png with data structure ?

Not applicable

Re: Data fully loaded, but partially displayed...

Here is the structure:

dataStructure.PNG

Thanks!

Not applicable

Re: Data fully loaded, but partially displayed...

could you paste tableu->coefficient formula?

Not applicable

Re: Data fully loaded, but partially displayed...

There is no formula... Just a SUM(COEF), with COEF a value of the 'FAIT' table.

Not applicable

Re: Data fully loaded, but partially displayed...

... is there any COEF with FAITH value?

Not applicable

Re: Data fully loaded, but partially displayed...

Hello!

I'm sorry to respond only now, but in the end it was a stupid mistake in the script: a join was bad...

Thank you anyway!