Failed to reload changed fields used in charts

[#1]

Hi,

I'm using one field called CUSTOMER in different charts, which at the time of making a reload sometimes substitutes the field called OFFICE. Both fields have data and is in the same table.

Any idea how to solve it?

[#2]

Hello

I think you should comment to support you more content

example, the two fields are in the same table?

regards

[#3]

Thank you for your response.

Annex image with the diagram:

  

I use the Customer field primarily for customer counting:

                   COUNT({$<Year={$(=Only(Year))}>} DISTINCT CLIENTE)

It is worth mentioning that the CLIENTES table has many records, I think that's why the fields are changed.

[#4]

hi

Use this test

COUNT(DISTINCT {$<Year={$(=Only(Year))}>} CLIENTE)

DISTINCT must not necessarily those with the client

regards

[Miguel_Angel_Baeyens]

Hi,

You may use a counter in the script so if the customer number does not exist, set the field to 1, otherwise to 0, son the final expression is something like:

Sum(COUNTER_CLIENTES)

Apart from that, can you elaborate on what do you mean by "fields are changing"?

Hope that helps.

Miguel

[#6]

I am using a Count(CLIENTE) in several charts, If  I close QlikView and  I open it again and I check my charts every single place where I use CLIENTE QlikView changed it by OFFICE.

[Miguel_Angel_Baeyens]

Hi,

That's quite strange indeed. Is the load binary, normal script...? Does that happen in any computer or only in some?

Miguel