Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Percentage and value at the same time in the bar chart (SENSE)

I used the dual () function but it did not work. I tried duplicating the expression, I could not!

That's in Qlik Sense.
Could someone guide me?
chart1.jpgThank you.

Labels (1)
5 Replies
MK_QSL
MVP
MVP

use something like below

Dual(

     Num(SUM(Sales),'#,##0') & ' ' & Num(SUM(Sales)/SUM(Total Sales),'#0.00%'), SUM(Sales))

Instead of SUM(Sales) use your expression here..

Not applicable
Author

Hello, thank you very much for your help.

As you can see, I did this too, but it did not work.

I tested other different attempts, but still did not work!

Could I be doing the expression in the wrong place?chart2.jpg

MK_QSL
MVP
MVP

make sure you don't format the expression in number.

rafaelencinasfarol
Partner - Contributor
Partner - Contributor

You must set to work

print.jpg

theoat
Partner - Creator III
Partner - Creator III

When using the Dual function, in order for the text displayed in the label to be the one set in the Dual, you must make sure that you have set the format of the measure to "Measure Expression". Also, make sure you have your data labels displayed.

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.