So you want the value of the ID by id shown per customer but you dont want to use the ID?
Then somehow you have to make the customer unique to seperate them.
(because now you ask the sum of the values per costumer, so Yahoo will be summed)
If you don't want to use the ID you could add something else to make it unique.
Take a look at this and let me know if it works for you:
'1' as counter;
LOAD * INLINE [
id, Customer, Value
1548, google, 10000
1578, yahoo, 5000
1648, msn, 1000
1487, yahoo, 5000
487, altavista, 500
Sum(counter) as UQ
Group by Customer;
IF(UQ =1, Customer, Customer& ' '& RowNo()) as Customer2
Drop field UQ, counter from TestTable;
This will create a new Customer field (named it Customer2) which adds the rownumber to the customer when there is more then 1 ID for this customer.
Maybe not the perfect solution but maybe you can work from here.
TestQlikview.qvw 121.8 K