topic Re: same custid with different cust name in QlikView

same custid with different cust name

gauthamchilled — Wed, 25 Nov 2020 16:16:04 GMT

hi,

in my data set, i would like to check and show in a straight table or in chart about the data with same custid but different name across same country but different period,

find the attached example...

Re: same custid with different cust name

RonaldDoes — Tue, 30 May 2017 14:26:33 GMT

Hi Gautham,

A quick way would be to add them to a pivot chart.

Does that work in your case?

I've attached my example. Hope it helps.

With kind regards,

Ronald

Re: same custid with different cust name

Peter_Cammaert — Tue, 30 May 2017 14:27:47 GMT

This seems spelling-related, not master data-related. Was the Customer Name in your data a free field, to be completed by whoever was entering the data?

In that case, you should perform a data quality check and decide on the correct names for those Customer IDs that have multiple Customer Names. Using a mapping table and an applymap() call, you can perform dimension data correction on the fly.

Re: same custid with different cust name

gauthamchilled — Wed, 31 May 2017 02:44:18 GMT

Yes Peter, Each year the customer details has been entered without checking whether it is existing or not...so these kinds of data quality issues are happening.

I wanted to analyse the data issues in a chart and show it as quality report of these.

Then the management need to decide whether to be corrected at the source or to be corrected at the dashboard by having a mapping table.

Thanks,

Gautham

Re: same custid with different cust name

gauthamchilled — Wed, 31 May 2017 02:49:40 GMT

Hi Ronald,

Your pivot shows everything..but i just need customer with same id but different name across different periods within same country.

-Thanks

Gautham

Re: same custid with different cust name

Digvijay_Singh — Wed, 31 May 2017 03:40:36 GMT

You can show like this, you may hide the last column thru presentation tab -

Re: same custid with different cust name

Digvijay_Singh — Wed, 31 May 2017 03:43:37 GMT

This should be the improved one -

Count(distinct Total<Country,CustID,CustName> {<CustName={"=Count(Year) > 1"}>}CustName)

Re: same custid with different cust name

gauthamchilled — Wed, 31 May 2017 06:00:10 GMT

Hi DigVijay,

I just want to compare for all the periods available in the dataset, not just current year vs previous year.

Also my year is in this format, FY2015,MY2015,FY2016,MY2016

FY - full year -jan to dec

my-mid year-last year july to current year june

Thanks for your help.

Gautham

Re: same custid with different cust name

RonaldDoes — Wed, 31 May 2017 06:43:04 GMT

Hi Gautham,

A calculated dimension like the following counts the unique CustNames for each CustID. Only showing CustID's with more than one name would meet your criteria, it seems to me.

=If(
Aggr(Count(DISTINCT CustName), CustID) > 1,
Aggr(Count(DISTINCT CustName), CustID),
Null())

Hope this helps you. I've attached the app with above updated example.

With kind regards,

Ronald

Re: same custid with different cust name

Digvijay_Singh — Wed, 31 May 2017 11:49:22 GMT

I think the expression I suggested works for multiple periods as I am just checking if a custname( aggregated by Country, CustID and Name) is used across multiple year(if count(year) >1), and if Yes, then show those records.

The format of year doesn't matter as I am counting the values of Year field if it is more than 1 against a custname.

If you can share the data sample where its not working, I can identify the reason of not working. Thanks