Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

List field values as Comma Separated Text

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.

1 Solution

Accepted Solutions
JonnyPoole
Employee
Employee

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

View solution in original post

5 Replies
JonnyPoole
Employee
Employee

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

Not applicable
Author

Thank You!

ishanbansal1204
Contributor III
Contributor III

This is giving me an error saying :Invalid Dimension"

JonnyPoole
Employee
Employee

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
Partner
Partner

How can we do it for multiple dimensions ?