returning multiple values using Only() function

Anonymous — Thu, 01 Jun 2017 19:28:15 GMT

Hello everyone,

I have a chart where I'm using set analysis with an alternate state to return values based on 'metric labels'.

My issue is coming from when a user has multiple values in for one metric and I need to show both.

My current expressions looks like this:

only({<[Metric Label]={'Metric1'}>}Detail_Field)

only({<[Metric Label]={'Metric2'}>}Detail_Field)

only({<[Metric Label]={'Metric3'}>}Detail_Field)

To illustrate:

I'm currently using the Only() function to return the values per metric per user. When there are 2 values for a metric, it returns a null value:

User ID	Metric1	Metric2	Metric3
001	-	Metric2Detail	Metric3Detail

When I remove the only() function, this is what I get:

User ID	Metric1	Metric2	Metric3
001	-	Metric2Detail	Metric3Detail
001	Metric1Detail1	-
001	Metric1Detail2	-

So you can see, I have 2 details in Metric 1, but since Qlikview doesn't know what value to use under the Only() function, it returns a null value.

What I'm trying to get is a single row per user. If there are 2 details within a metric, I want them to all be within the same cell.

User ID	Metric1	Metric2	Metric3
001	Metric1Detail1 Metric1Detail2	Metric2Detail	Metric3Detail

User ID

Metric1

Metric2

Metric3

001

Metric1Detail1

Metric1Detail2

Metric2Detail

Metric3Detail

Is this 3rd table achievable?

Thank you in advance

Re: returning multiple values using Only() function

RSvebeck — Thu, 01 Jun 2017 20:50:55 GMT

try this:

concat({DISTINCT <[Metric Label]={'Metric1'}>}Detail_Field,CHR(13))