topic Re: different name with same id, help? in QlikView

different name with same id, help?

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

There are two cases in the data,

1. same client id, two different names

2. same name, two different client id

So i always search by client name in the dashboard and want the dashboard to show data by client id of that client name.

In the attached example, i have two differnt company name one is 'Xyz' and other is 'xyz'. if i search either by Xyz or xyz i want the dashboard data

to be based on the client id, but it is not doing that way.

I dont want to use mapping or look up because, the data quality cannot be controlled by us. so i want to search by client name and do the

aggregation by client id.

how can i achieve this? any help please

Frank_Hartmann — Thu, 28 Jul 2016 08:44:26 GMT

have a look at the youtubevideo:

hope this helps

Thu, 28 Jul 2016 08:51:36 GMT

If I get you right you can use the AGGR() function for this.

Try this one:

=Aggr(sum(Sales),ID)

Load the table within the script using GroupBy.

Sample:

Load

ID,

MaxString(CompanyName) as CompanyName,

SUM(Sales) as Sales

GROUP BY

;

Load * inline

[

ID,CompanyName,Year,Sales

100,ABC,2015,23400

110,aBC,2015,32100

210,DEF,2014,33000

200,Xyz,2015,12100

200,xyz,2013,23000

];

gauthamchilled — Thu, 28 Jul 2016 09:53:52 GMT

Thanks for the reply Frank. But the case is some client names are same with different client id, some client names are differnt with same client id.

Youtube says only about same client names. I want to search by client name, but show the results by their associated client id