Qlik Community

Qlik Brasil

Group community for Brazil users. discussion only in Portuguese.

Highlighted
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.

3 Replies

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

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

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

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

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

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