topic Re: Data mismatch in Qlikview in QlikView

Data mismatch in Qlikview

JeevanS — Thu, 20 Mar 2025 15:56:15 GMT

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.

Re: Data mismatch in Qlikview

rwunderlich — Wed, 19 Mar 2025 02:18:24 GMT

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

-Rob

Re: Data mismatch in Qlikview

Dana_Baldwin — Mon, 24 Mar 2025 20:48:00 GMT

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

Re: Data mismatch in Qlikview

Somight1948 — Wed, 18 Jun 2025 06:50:40 GMT

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

Re: Data mismatch in Qlikview

Mark_Little — Tue, 17 Jun 2025 07:29:00 GMT

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