topic Re: List field values as Comma Separated Text in QlikView

List field values as Comma Separated Text

Tue, 16 Sep 2014 00:00:36 GMT

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.

Re: List field values as Comma Separated Text

JonnyPoole — Tue, 16 Sep 2014 00:02:24 GMT

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

Re: List field values as Comma Separated Text

Tue, 16 Sep 2014 17:46:23 GMT

Thank You!

Re: List field values as Comma Separated Text

ishanbansal1204 — Fri, 06 Jul 2018 07:42:54 GMT

This is giving me an error saying :Invalid Dimension"

Re: List field values as Comma Separated Text

JonnyPoole — Tue, 10 Jul 2018 05:47:04 GMT

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

Re: List field values as Comma Separated Text

akshay_mahapadi — Mon, 23 Jul 2018 13:03:56 GMT

How can we do it for multiple dimensions ?