Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
slondono
Partner - Creator II
Partner - Creator II

Concatenate another expression to a result

Hi everyone

Someone knows a way to concatenate 2 expressions in 1? I mean...i have a horizontal bar diagram that is counting people per region, but my cliente need the percentaje of that people in front of the quantity. Something like this.

helios barras.png

I tried to concatenate that in the expression...like a Count(People)&' - '&Expression2. But isnt work

Some idea??

3 Replies
sunny_talwar

Try this:

Dual(Count(People)&' - '&Expression2, Count(People))

sunny_talwar

Make sure to select Expression Default for formatting on the Numbers tab of chart properties

maxgro
MVP
MVP




Dual( num(count(People), '#.##0') & ' - ' & num(count(People) / count(TOTAL People), '#.##0,00%'), count(People))

1.png