# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor

## Is there a way to display multiple values as a single measure?

Hi all,

Say my data has a dimension column as People's names, the next three columns are measures about these people, say Height, Weight, and Age.  Can I display as a single measure a KPI that shows the three statistics on one measure?

What I want is: "Jon Doe: 6'3", 180 pounds, 45"

To make it more interesting, I'm trying to use the Marquee_Vizplum extension to display this information about each person as a rolling ticker.  I'm stuck with being only able to display one statistic.

Thank you,

Olivier

1 Solution

Accepted Solutions
Honored Contributor III

## Re: Is there a way to display multiple values as a single measure?

Go to measures and build them by using "&" and single quotes ' to put any text/string in between

for example

sum(Weight) & ' pounds, ' & sum(Height)

cheers

Lech

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

5 Replies
Contributor II

## Re: Is there a way to display multiple values as a single measure?

Something like this?

= DimName & ': ' & DimHeight & ', ' & DimWeight & ' pounds, ' & DimNo4

I don't know Marquee_Vizplum extension so I don't know if it will work.

Honored Contributor III

## Re: Is there a way to display multiple values as a single measure?

Go to measures and build them by using "&" and single quotes ' to put any text/string in between

for example

sum(Weight) & ' pounds, ' & sum(Height)

cheers

Lech

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Contributor

## Re: Is there a way to display multiple values as a single measure?

Thanks Lech, that worked.  Only thing is that the number formatting for the value no longer works so I need to include the formatting in the expression for each measure.

Olivier

Honored Contributor III

## Re: Is there a way to display multiple values as a single measure?

yes, that is correct

so the number formatting you can achieve by using num() function:

num(sum(Weight),'format') & ' pounds, ' & num(sum(Height),'format')

details here:

Num - script and chart function ‒ Qlik Sense

Contributor

## Re: Is there a way to display multiple values as a single measure?

Yes, I was able to make it work.

Thanks a lot.