different name with same id, help?

[gauthamchilled]

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]

have a look at the youtubevideo:

Qlikview Set Analysis LIKE & * RFB 138 - YouTube

hope this helps

[#3]

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

Try this one:

=Aggr(sum(Sales),ID)

Or

Load the table within the script using GroupBy.

Sample:

Load

  ID,

  MaxString(CompanyName) as CompanyName,

  SUM(Sales) as Sales

GROUP BY

  ID

;

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]

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