Incorrect mapping happening in Qlik

[debmsarkar123]

When  I am selecting only " 100049800" in Field 1 the value in field 3 is coming to be  395.17 as shown in the below screenshot-

When  I am selecting  " 100049800" in Field 1  and "4503409701" in Field 2 the value in field 3 is coming to be  452 as shown in the below screenshot-

The correct value of field 3 for 100049800" in Field 1  and "4503409701" in Field 2 is 452 which is coming when selecting both the fields.

Could you please tell me why this is happening? Seems like the source data is correct otherwise in screenshot 2 the data wont be correct.

[SankarReddy]

Hi @debmsarkar123 ,

Thanks for posting the query.

Could you please create a support ticket for further investigation? please attach sample qvw , along with sample data and Qlikview version.

Best Regards,

Sankar.

[debmsarkar123]

Why should I open a support ticket? It's not a bug in qlikview

[Lisa_Sun · Accepted solution]

Yes logging a support ticket is a better way to troubleshoot in this case. More investigation is required on the qvw. It seems related to the logic designed in this qvw.  The qvw has confidential data which should not be exposed in this community as well.  

The best way to debug is to do below:

1. create a new qvw.  create one table chart to include field 1, 2 and 3. Then see if the data is correct.

2. On the existing qvw, remove all other columns to only keep these three fields in both charts. If the issue still exists, check the field 3 on both qvw and what is the difference.