After charging a new table I lost the data from a table I already had

[JordiL]

Hi colleages, 

I've recently start working with qlikview and i've found a problem that I am not undestarding. 

I have a serie of linked tables where I get some data. After i charge a new table, where I also link it with the old tables the formulas i was using to use the data from the first table stop working. 

These are the linked table #1:

After charging the new table:

I was using this formula (for giving an example):

num( Count({< realizado = { '2'} > }[Id TPM]))

The result was 49 and after chargin the new table, the result is 0. 49 is the correct result, what could be happening that is disturbing my data?

I'm not sure if this is the correct qlikview page for this question, If not someone could move it to the correct forum.

[abhijitnalekar]

Hi @JordiL ,

As I can see from the Data model after adding a new field loop has been generated. 

Once you remove that you will get the appropriate output

[JordiL]

Hi @abhijitnalekar,

Thank you for your answer.

Not sure which one are you refering?  

Maybe it's the lenguage, as I'm not sure what is a field loop in qlikview.

But I've created all the relations needed for connecting the tables. How can I solve it maintaining the correct connections?

[abhijitnalekar]

Hi @JordiL,

Identify the relationship between the table to join with lenguage table.

and remove other remaining joins from the respective table.

Hope this helps you