Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
Not applicable

Bar Chart with number and percentage

Hi,

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

Sem título.png

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

1 Solution

Accepted Solutions

Re: Bar Chart with number and percentage

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

7 Replies

Re: Bar Chart with number and percentage

May be like this:

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

Not applicable

Re: Bar Chart with number and percentage

Capturar.PNG

It not worked here 😕

Re: Bar Chart with number and percentage

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

galax_allu
Valued Contributor

Re: Bar Chart with number and percentage

try this

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

OR

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




Not applicable

Re: Bar Chart with number and percentage

Here is the qvf

Re: Bar Chart with number and percentage

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

Not applicable

Re: Bar Chart with number and percentage

I was expecting that, thanks for the help!