topic Re: Concatenate another expression to a result in QlikView

Concatenate another expression to a result

slondono — Fri, 03 Jun 2016 19:44:05 GMT

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.

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

Some idea??

Re: Concatenate another expression to a result

sunny_talwar — Fri, 03 Jun 2016 19:45:03 GMT

Try this:

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

Re: Concatenate another expression to a result

sunny_talwar — Fri, 03 Jun 2016 19:45:59 GMT

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

Re: Concatenate another expression to a result

maxgro — Fri, 03 Jun 2016 19:59:13 GMT

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