Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
May be like this:
Dual(Sum(FATURADO) & Chr(10) & Num(Sum(FATURADO) / Sum(TOTAL FATURADO), '#.##0,00%'), Sum(FATURADO))
It not worked here 😕
Would you be able to share you qvf to check this out?
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)
Here is the qvf
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
I was expecting that, thanks for the help!
You can use Dual() and do not forget to set "Number Formatting" to measure expression.