troubles with set analysis and aggr

[#1]

I have a qlikview document containing data about some customers. There is CustomerID field and a CustomerName field, but CustomerName is not always present in the data.

I want to concatenate all the CustomerID that have an associated CustomerName in a TextObject, without regard for the current selection state.

I first tried the following expression:

=concat(aggr(distinct CustomerName, CustomerID))

It works but only returns value associated with the selected/possible values of CustomerID. So I added {1} to my expression to evaluate it on the complete data set:

=concat(aggr(distinct {1} CustomerName, CustomerID))

then:

=concat({1}aggr(distinct CustomerName, CustomerID))

and even:

=concat({1}aggr(distinct {1}CustomerName, CustomerID))

But none of the above worked as I want. How can I achieve what I want?

[Gysbert_Wassenaar]

Use a straight table instead with CustomerID as dimension and concat({1} distinct CustomerName) as expression

[#3]

Unfortunately I have to use a single expression and not a chart object with dimensions and expressions. Is it possible?

[Gysbert_Wassenaar]

Maybe concat({1} distinct aggr(concat({1} distinct CustomerName),CustomerID))