Data mismatch in Qlikview

[JeevanS]

I have a straight table where i found duplicate values. To remove duplicate i used aggr function. Now I am getting single value and null for some record. Now I want to remove the null from the measure value. How can i achieve that.

[rwunderlich]

Note that Aggr is Distinct by default. You may need to add the NoDistinct keyword in your Aggr.

-Rob

[Dana_Baldwin]

Hi @JeevanS 

Please note the forum you have posted to is for Compose, a Data Integration product. To reach your target audience, please consider posting your question here: https://community.qlik.com/t5/Qlik-Sense/ct-p/qlik-sense

Thanks,

Dana

[Somight1948]

Data mismatch in QlikView can refer to various discrepancies, such as inconsistencies between data in different tables, between the data model and source data, or unexpected results due to incorrect data types or formatting. These issues can arise from various causes like incorrect data loading, data transformations, or issues with the data source itself.

Cuyahoga County Auditor Property Search

[Mark_Little]

It would probably help if you share you set analysis and little more about your data structure.