topic Re: Bar Chart with number and percentage in App Development

Bar Chart with number and percentage

Sat, 16 Nov 2024 10:20:24 GMT

Hi,

I need to create a bar chart in Qlik Sense, something like that:

So as you can see there is two values in each bar, actually they are the same number but in different formats, one is in numeric value and other is in percentage

I was looking to use one of these expressions

dual(Sum(FATURADO),Num(Sum(FATURADO) / Sum( TOTAL FATURADO), '#.##0,00%'))

num(Sum(FATURADO),'#.##0,00')&' ('&Num(Sum(FATURADO) / Sum( TOTAL FATURADO), '#.##0,00%')&')'

But this not worked how I was expecting

Someone can help me on that?

Thanks

Re: Bar Chart with number and percentage

sunny_talwar — Wed, 05 Oct 2016 17:04:26 GMT

May be like this:

Dual(Sum(FATURADO) & Chr(10) & Num(Sum(FATURADO) / Sum(TOTAL FATURADO), '#.##0,00%'), Sum(FATURADO))

Re: Bar Chart with number and percentage

Wed, 05 Oct 2016 18:26:24 GMT

It not worked here 😕

Re: Bar Chart with number and percentage

sunny_talwar — Wed, 05 Oct 2016 18:38:12 GMT

Would you be able to share you qvf to check this out?

Re: Bar Chart with number and percentage

Anonymous — Wed, 05 Oct 2016 18:48:01 GMT

try this

Dual(num(sum(FATURADO),’#,##0,00%’), sum(FATURADO)

Dual(num(sum(FATURADO),’#,##0,00%’) & Repeat(chr(13)&chr(10), rank(Sum(FATURADO))-2), sum(FATURADO)

Re: Bar Chart with number and percentage

Wed, 05 Oct 2016 19:11:44 GMT

Here is the qvf

Re: Bar Chart with number and percentage

sunny_talwar — Wed, 05 Oct 2016 19:47:06 GMT

Seems like there is no way to display expression default formatting. This was something which was available in QlikView, but doesn't seem to be in Qlik Sense. I tried another way to do this, but even that one didn't work. I am sorry, but I am out of ideas, may be a Qlik Sense expert might be able to offer some good advice

Re: Bar Chart with number and percentage

Wed, 05 Oct 2016 20:06:43 GMT

I was expecting that, thanks for the help!

Re: Bar Chart with number and percentage

fd — Mon, 10 Feb 2020 12:06:36 GMT

You can use Dual() and do not forget to set "Number Formatting" to measure expression.