How to handle a field that is not found

[pgalvezt2021]

Hello !!!!

How could I do it so that when adding the "customer" field it does not cause problems with the quantity and inventory balance. Since when I export to Excel it adds another amount.

PS: the first section is nothing more than the same two tables but separated just to see the real data. and the second is union.

Thank you !!!!

[TcnCunha_M]

could you check if the values added are not duplicated values?

if it is, just add distinct in your expression or solve the duplicated records.

[Aditya_Chitale]

didn't understand the issue. can you explain in detail ?

Regards,

Aditya

[anat]

It depends on the level of granularity btn customer, quantity and inv balance... 

You have to analyse the data if any impact of balance after adding customer field

[pgalvezt2021]

Hello Everyone,

Thank you for your replies !!!!

After analyzing everything very carefully, I have realized that Qlik is calculating correctly. And that it would be a business issue that has already been explained and understood by the business itself.

Thank you !!!!