List field values as Comma Separated Text

[#1]

Does anyone know how to show the values in a field as comma separated text in QlikView?

I don't want to export my data as a CSV, and I don't necessarily mean fields that are currently selected.

Say you have:

Date                 Customer Name                Sales

1-Jan                ABC                                   $100

1-Jan                DEF                                   $200

1-Jan                GHI                                    $100

Then I want to show, on 1-Jan, the customers in one text field as:

ABC,

DEF,

GHI

Anyone know how to do this? The ultimate purpose is to show the customers as a "Pop-up" on a bar chart. So that I can see sales over time and when I hover over a particular day, I can see who the sales were made to.

Thanks!

Abhijeet.

[JonnyPoole · Accepted solution]

sure with only date as the dimension, add an expression like this:   concat( distinct  [Customer Name] ,',')

[#3]

Thank You!

[ishanbansal1204]

This is giving me an error saying :Invalid Dimension"

[JonnyPoole]

the expression isn't valid for a dimension.  With Qlik Sense an 'expression' would be a 'measure'.  Try the expression as a measure with date as the dimension

[akshay_mahapadi]

How can we do it for multiple dimensions ?