Calculated Dimension Error

[Qlikuser09]

"I'm trying to add this as my calculated dimension but it shows invalid dimension "=Concat (Total<Customer_id> [Products],',')"  

[stevejoyce · Accepted solution]

Try this and see if this is what you are looking for.  If not, can you explain what you are trying to show.

=Aggr(Concat (Total<Customer_id> [Products],','), Customer_id)

[Qlikuser09]

thanks, it worked it dint display an invalid dimension !!! but  however it gave me duplicate fields in the bar chart. So i used , =if ((customer_id) > 1, Aggr(Concat (Total<[Customer_id]>  [Products],','), [Customer_id]),( [Products] )), 

even this did not work for me.